If the grades are in column A, this function gives Letter Grades
according to:
= 90, A
= 80 (less than 90), B
=70, C
= 50, D
< 50, F


=IF(A1=90,"A",IF(A180,"B",IF(A170,"C",IF(A1=50 ,"D","F"))))


--
crispbd
------------------------------------------------------------------------
crispbd's Profile: http://www.excelforum.com/member.php...o&userid=10880
View this thread: http://www.excelforum.com/showthread...hreadid=274338