You can convert the letters to number using match

=MATCH(F1,{"F","D","C","B","A"},0)-1


Do you have grades using A+ and A-

Then use lookup

=MATCH(F1,{"F","D","C-","C","C+","B-","B","B+","A-","A","A+";0,.5,1,1.5,1.5,2.0,2.5,2.5,3.0,3.5,3.5, 4.0,4.5})-1


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=149564