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