MrExcel Publishing
Your One Stop for Excel Tips & Solutions


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

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


You can use: