very bacis IF formula - not working

[p.nela]

Hello,
I would like to ask for help with very basic IF formula - the typical example with intervals : it is working only for number 75 and it shows "a", with other, lower number it is automatically "fail" option. I couldnt find the mistake, if u please could help me.

=IF(G9>=75;"a";IF(G9>=60<75;"b";IF(G9>=40<60;"c";"fail")))

thank you.

[shukla.ankur281190]

Try

=IF(G9>=75;"a";IF(AND(G9>=60;G9<75);"b";IF(AND(G9>=40;G9<6);"c";"fail")))

[Richard Buttrey]

...another approach

Please Login or Register  to view this content.

[p.nela]

Thank you for answer. It worked.
I woule like to also ask how I could define weather I shoud you only IF(IF...)functions and IF(AND)IF function- because in the tutorial video I wathech they used with very similar task just IF(IF...))function and IF(AND(IF...)) was with multiple numbers/logical test values.
thank you.

[shukla.ankur281190]

Yes It can be done with simply as below. I didn't realize at that moment.

=IF(G9>=75;"a";IF(G9>=60;"b";IF(G9>=40;"c";"fail")))

[p.nela]

Oh, yes, now I see my mistake with >=60<75 that´s why it wasnt working.´

thank you very much again

[shukla.ankur281190]

Glad it help you and thanks for feedback.

Please marks as it solved if your problem has now solved

[Special-K]

or try

=LOOKUP(G9,{-1E99,40,60,75},{"fail","c","b","a"})

[Khalidngo]

Hi to all,

Another approach could be:

=CHOOSE(MATCH(G9,{0,40,60,75},1),"Fail","c","b","a")

Blessing