Logical operator

[usr7501]

Hello,

Can I use some kind of operand where I say that only score 71-80 will be assigned an "A" in the enclosed expression?

=IF(A12>71,"A",IF(A12>=57,"B",IF(A12>=40,"C","F")))

 

[shrivallabha]

You can add AND like:
=IF(AND(A12>=71,A12<=80),"A",IF(A12>=57,"B",IF(A12>=40,"C","F")))
but that will produce wrong results if someone has 81 (and probably we are looking at grades).

Explain what shall be output when value exceeds 80.

 

[usr7501]

E

You can add AND like:
=IF(AND(A12>=71,A12<=80),"A",IF(A12>=57,"B",IF(A12>=40,"C","F")))
but that will produce wrong results if someone has 81 (and probably we are looking at grades).

Explain what shall be output when value exceeds 80.

Just to clarify. Score 81 should not be evaluated. One of the solutions I have is the one you mention, like minded brains think the same.

I am, not sure what a good way is to cut off evaluation when entering 81+ and how the ending of evaluation is done in a neatly way. That is why I am posting. Is there a better way than IF statements or can it be done w/ an IF statement?

You are absolutely correct. It is about grades.

 

[Deepak]

Is this...

=LOOKUP(A12,{0,40,57,71,81},{"F","C","B","A",""})

 

[S. Das]

You can use this also
=IF(A12<40,"D",IF(A12<57,"C",IF(A12<71,"B",IF(A12<81,"A",IF(A12>=81,"E")))))