help needed in IF function

[DaredEvil590]

HI everyone,,

I need to know what's wrong in this forumla:

=IF(E5>94,"A",IF(E5>89,"A-",IF(E5>85,"B+",IF(E5>82,"B",IF(E5>79,"B-",IF(E5>75,"C+",IF(E5>72,"C",IF(E5>69,"C-",IF(E5>59,"D",IF(E5>0,"F",))))))))))

==============
I need your help as soon as possible.



Thank you :

 

[Guest]

Hi

Have a look at this:
http://www.cpearson.com/excel/excelF.htm#Grades

It should help you to sort it out. The reason your formula is not working is
because you are only allowed 7 nested IFs.

Hope this helps!
Andy.

"DaredEvil590" <[email protected]>
wrote in message
news[email protected]...

 

[Bob Phillips]

You have too many nested functions, so this approach cannot work.

Try

=VLOOKUP(E5,{0,"F";60,"D";70,"C-";73,"C";76,"C+";80,"B-";83,"B";86,"B+";90,"
A-";95,"A"},2)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"DaredEvil590" <[email protected]>
wrote in message
news[email protected]...

 

[DaredEvil590]

thanks guys for ur help

it really worked.


thanks

 

[DaredEvil590]

Hi Bob Phillips,

I used the formula that you gave it to me

=VLOOKUP(E5,{0,"F";60,"D";70,"C-";73,"C";76,"C+";80,"B-";83,"B";86,"B+";90,"
A-";95,"A"},2)

everything is okay, but the problem is when I insert a grade between(
90-95) which suppose to get me ( A-) i got an error.

please help me to solve this problem, soon.


thank you very much