<< 100-95 A
94-90 A-
89-87 B+
86-83 B
82-80 B-
79-77 C+
76-73 C
72-70 C-
69-67 D+
66-60 D
60 F

First of all, the last line should read "<60" and not "60." Here is
what you need to do.

In Cells A1 to A11, enter the following numbers,

0,60,67,70,73,77,80,83,87,90,95

and in Cells B1 to B11, enter the corresponding alpha grade

F,D,D+,C-,C,C+,B-,B,B+,A-,A


In Cell D1, enter this formula,

=IF(C1=\"\",\"\",VLOOKUP(C1,A1:B11,2))

where C1 is where you enter the numeric grade and Cell D1 will give you
the equivalent alpha grade.

Hope this is what you are looking for.

Regards.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=397403