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

=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

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

You are welcome! Thanks for the feedback!
Stefi

€žCherylR€� ezt Ã*rta:

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

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