Yes, all you need to is alter the lookup value and corresponding grades.
=LOOKUP(A1,{0,50,56,61},{"D","C","B","A"})
HTH
JG
"mevetts" wrote:
Can it be done so a range of numbers applies to a certain grade?
Example -
50-55 = C
56-60 = B
61-100 = A
--
mevetts
------------------------------------------------------------------------
mevetts's Profile: http://www.excelforum.com/member.php...o&userid=29130
View this thread: http://www.excelforum.com/showthread...hreadid=499985