One way to go:

=LOOKUP(A1,{1,66,79,87,93;"F","D","C","B","A"})

And copy down as needed.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"goodmike" wrote in
message ...

I'm looking for the function that returns a grade (a,b,c,d,f) for
numerical values (100,92,86,78,65) ......help mike

?????(100,92,86,78,65),(A,B,C,D,F)


--
goodmike
------------------------------------------------------------------------
goodmike's Profile:
http://www.excelforum.com/member.php...o&userid=30936
View this thread: http://www.excelforum.com/showthread...hreadid=506936