braincramp

G

goodmike

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

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

Bernard Liengme

Go to Help for info on LOOKUP, VLOOKUP and HLOOKUP
come back if more help needed
best wishes
 
R

RagDyer

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!
==============================================
 
Top