Hi guys
Think I am overlapping my criteria in an IF function which is not giving me right results.
Please help:
=IF(P2>99,"2",IF(P2<=98,"1",IF(P2<=96,"0")))
I want to define if someone gets a score of 98 or below, their grade is 1.
If they get 96 or below they get 0. But I am not seeing 0 in my results?
pls advise
many thanks!
Bookmarks