Formula Help
Hi,
Here's another way:
=LOOKUP(A2,{0,50,60,70,80,90},{"U","D","C","B","A" ,"A*"})
Regards!
Jean-Guy
"CherylR" wrote:
I am trying to convert a number within a range to a grade and I would be
grateful for some help as I'm not sure what formula to use:
<50 = U
50-59 = D
60-69 = C
70-79 = B
80-89 = A
90-100 = A*
Many thanks,
Cheryl
|