Excel formula help

[sam8]

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",""))))))))))

 

[Jacob Skaria]

Let us know whether if it is an error OR returning wrong answers.

If returning wrong answers check the cell format of L11. Change that to
General if not. If it is an error make sure you have copied the formula
right..


If this post helps click Yes

 

[Jacob Skaria]

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

 

[sam8]

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

 

[Bernd P]

Hello,

...
But still I don't understand why the previous formula didn't work.
...

Too many nested IF's. 7 is max.

Regards,
Bernd

 

[Jacob Skaria]

2003 do not allow more than seven IF conditions...Go for an alternate..

If this post helps click Yes

 

[sam8]

Thank you very much.
Samuel

2003 do not allow more than seven IF conditions...Go for an alternate..

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

Let us know whether if it is an error OR returning wrong answers.

[quoted text clipped - 12 lines]

 

[sam8]

Hi Mr Bernd,
Thank you very much
Samuel

Hello,


Too many nested IF's. 7 is max.

Regards,
Bernd