Formula Help
Thanks Stefi, that worked perfectly,
Cheryl
"Stefi" wrote:
=IF(A2<50,"U",IF(A2<=59,"D",IF(A2<=69,"C",IF(A2<=7 9,"B",IF(A2<=89,"A","A*")))))
Regards,
Stefi
€˛CherylR€¯ ezt Ć*rta:
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
|