Excel formula help
 

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

Excel formula help
 

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


"sam8" wrote:

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

Excel formula help
 

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


"sam8" wrote:

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

Excel formula help
 

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

Excel formula help
 

Hello,

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

Too many nested IF's. 7 is max.

Regards,
Bernd

Excel formula help
 

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

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


"Jacob Skaria" wrote:

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


"sam8" wrote:

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

Excel formula help
 

Thank you very much.
Samuel

Jacob Skaria wrote:
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]
(L11=73,"B-",IF(L11=70,"C+",IF(L11=67,"C",IF(L11=60,"C-",IF(L11=55,"D",
IF(L11<=54,"F",""))))))))))

Excel formula help
 

Hi Mr Bernd,
Thank you very much
Samuel

Bernd P wrote:
Hello,

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

Too many nested IF's. 7 is max.

Regards,
Bernd