Formula Help

G

Guest

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
 
G

Guest

=IF(A2<50,"U",IF(A2<=59,"D",IF(A2<=69,"C",IF(A2<=79,"B",IF(A2<=89,"A","A*")))))

Regards,
Stefi


„CherylR†ezt írta:
 
G

Guest

Thanks Stefi, that worked perfectly,

Cheryl

Stefi said:
=IF(A2<50,"U",IF(A2<=59,"D",IF(A2<=69,"C",IF(A2<=79,"B",IF(A2<=89,"A","A*")))))

Regards,
Stefi


„CherylR†ezt írta:
Click to expand...
 
G

Guest

Hi,

Here's another way:

=LOOKUP(A2,{0,50,60,70,80,90},{"U","D","C","B","A","A*"})

Regards!
Jean-Guy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Grades 2
Q: Excel function 2
VLOOKUP to find a value that falls between a range? 3
alternative formula for VLOOKUP since it stops with the 1st value itself 2
Select case statement advise 5
Nested IFs 6
Need (Excel) formula to make Mark sheet with Automatic Grading 15
formula to display cell address 2

Top