Let A1:B11 contain the following table...

0 F
60 D
67 D+
70 C-
73 C
77 C+
80 B-
83 B
87 B+
90 A-
95 A

Then, use the following formula...

=LOOKUP(C1,$A$1:$B$11)

....where C1 contains your numerical grade. Alternatively, you can
dispense with having a table and use the following formula instead...

=LOOKUP(C1,{0,60,67,70,73,77,80,83,87,90,95},{"F", "D","D+","C-","C","C+",
"B-","B","B+","A-","A"})

Hope this helps!

In article ,
"capecrusader0660" wrote:

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


"Excel_Geek" wrote:


Could you provide the numeric-to-alpha equivalents?


--
Excel_Geek


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