In your formula, if value in H24 LESS than 89 then put A, (everything
less than 89 will become A) else go to the next IF statement.

In this case if the value than 89 then 2nd IF will be triggered. But
the statements in this IF are all LESS than 89.

I think your formula may be like this.
=IF(H2489, "A", IF(H2479,"B", IF(H2469, "C","F")))

Only change the LESS THAN symbol to MORE THAN symbol.

Please forgive for my bad English.


--
hideki
------------------------------------------------------------------------
hideki's Profile: http://www.excelforum.com/member.php...o&userid=18903
View this thread: http://www.excelforum.com/showthread...hreadid=397481