Browse
Category
DiscussionsOff Topic

Need little help with excel

Closed
rex2630

Hi, mates! Can u please help me to fix problem with if function, please?help will be much apreciated :)
=IF(D13<60;"neprospěl";IF(D13>66:76;"prospěl";IF(D13>76:86;"dobře";IF(D13>86:96;"chvalitebně";IF(D13>96:106;"výborně";)))))
Why it not working?
Error code: #Value!
Thanks for any help! :)

7 years ago

Comment has been collapsed.

16 Comments
MeeMesmo

https://support.office.com/en-us/article/IF-function-69aed7c9-4e8a-4755-a9bc-aa8bbff73be2

7 years ago
Permalink

Comment has been collapsed.
rex2630

Thanks for link.But i doing it by this and no sulution yet.

7 years ago
Permalink

Comment has been collapsed.
MeeMesmo

, instead ; maybe, a long time ago since I used any office and values maybe you are getting duplicated because 86 instead using 87, unless you want them that way

7 years ago
Permalink

Comment has been collapsed.
Pilda

Hello, it's always nice to see someone from my country here. :)

7 years ago
Permalink

Comment has been collapsed.
rex2630

Čau :D .Tj., ale česká komunita zde roste, jak jsem se tak díval :)

7 years ago
Permalink

Comment has been collapsed.
Pilda

Tj, pár čechů tu je, ale mimo SG jsem ještě neviděl nikoho kdo by sem chodil. :D

7 years ago
Permalink

Comment has been collapsed.
fartheststar

I think you want this (or something close to this?)

=IF(D13<60,"neprospěl",IF(D13<76,"prospěl",IF(D13<86,"dobře",IF(D13<96,"chvalitebně",IF(D13<106,"výborně","other")))))

7 years ago
Permalink

Comment has been collapsed.
rex2630

Thanks for trying to help me, but it not working anymore :/

7 years ago
Permalink

Comment has been collapsed.
fartheststar

do note, anything from 60 to 76 will return prospěl

in the initial formulation you had 66:75. unsure if that was intended or not as all others were continuous ranges

7 years ago
Permalink

Comment has been collapsed.
rex2630

Oh, that really helped, but only one problem remains.Why i cant use =>?

7 years ago
Permalink

Comment has been collapsed.
Crocross

try >=

7 years ago
Permalink

Comment has been collapsed.
rex2630

Thanks.It worked ´maybe, than my pc lagged, excel crashed and i cant do anything.My all work is deleted :/ .I just hate excel

7 years ago
Permalink

Comment has been collapsed.
fartheststar

you can use >= if you like, but the logic would have to be reversed. The syntax you were initially using was not compatible with excel.

=IF(D13<60,"neprospěl",IF(D13<76,"prospěl",IF(D13<86,"dobře",IF(D13<96,"chvalitebně",IF(D13<106,"výborně","other")))))

could also be expressed (if I did it right)

=IF(D13>=106,"other",IF(D13>=96,"výborně",IF(D13>=86,"chvalitebně",IF(D13>=76,"dobře",IF(D13>=60,"prospěl","neprospěl")))))

7 years ago
Permalink

Comment has been collapsed.
rex2630

=KDYŽ(D7<60;"neprošel";KDYŽ(D7>=60;"prospěl";KDYŽ(D7>=70;"dobře";KDYŽ(D7>=80;"chvalitebně";KDYŽ(D7>=90;"výborně")))))
Only prospěl and neprošel working :/

7 years ago
Permalink

Comment has been collapsed.
rex2630

Sg community is awesome.Thank u guys!It works! :)

7 years ago
Permalink

Comment has been collapsed.
Crocross

It might help if you explain what you want it to do but I believe fartheststar has it right or at least very close

7 years ago
Permalink

Comment has been collapsed.

Closed 7 years ago by rex2630.