MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel


Posted by Stephanie Hopper on September 10, 2001 8:56 AM


I need help in creating a gradebook. I need the cell to look at the grade and compare it to a list of numbers if it is true it will return a letter grade. The problem is that I can't nest more then 7 if functions. How do I get around this.

expl: IF(Grade3>95.5,"A+")
I need to include Grades A through F including + and -

Can someone help
Steph


Posted by Aladin Akyurek on September 10, 2001 9:08 AM

Stephanie,

You can use:

=VLOOKUP(A1,{0,"F";60,"D";70,"C-";75,"C";77,"C+";80,"B-";85,"B";87,"B+";90,"A-";94,"A";98,"A+"},2,1)

Aladin

============