braincramp
 

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

braincramp
 

Go to Help for info on LOOKUP, VLOOKUP and HLOOKUP
come back if more help needed
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"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

braincramp
 

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