Wonderful! Great help indeed Mr Jacob.
It worked well.
But still I don't understand why the previous formula didn't work. I copied
correctly but it was returning error message. As I typed the formula and came
upto "D" and "F" the font color of L11 turned black instead of the selected
light blue color.
Error message:
THE FORMULA YOU TYPED CONTAINS AN ERROR
Thanks a lot

Jacob Skaria wrote:
You can also achieve this using LOOKUP() funciton which makes the formula
shorter and easy to modify....

=LOOKUP(B21,{0,54,55,60,67,70,73,76,80,85,90},{"F ","F","D","C-","C","C+","B-","B","B+","A-","A"})

If this post helps click Yes
---------------
Jacob Skaria

I'm trying to update assessment excel sheet of my college. I tried the
following formula for grades in 2007 excel and it worked fine. but the same
formula returns an error in 2003 excel. does anyone have a solution to this?
Formula: =IF(L11=90,"A",IF(L11=85,"A-",IF(L11=80,"B+",IF(L11=76,"B",IF
(L11=73,"B-",IF(L11=70,"C+",IF(L11=67,"C",IF(L11=60,"C-",IF(L11=55,"D",
IF(L11<=54,"F",""))))))))))