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
============
