school grades in a spreadsheet.

  • Thread starter Stressed School Teacher
  • Start date
S

Stressed School Teacher

Hi i'm wondering if someone could help me out or tell me that what i'm asking
is impossible.

I want to type a number in one cell and have a corresponding letter appear
simultaneously in another cell. For example if I type in "89"in one cell I
would want the letter "B"to appear in another cell. There are different
ranges for each letter so from 0-60 would be "E", 61-70 would be "D", 71-80
would be "C", 81-90 would be "B" and 91-100 would be "A".

I really don't know where to start with this one so any help would be
greatly appreciated.

Thanks in advance.

Adrian
 
J

JE McGimpsey

One way:

=LOOKUP(A1,{0,"E";61,"D";71,"C";81,"B";91,"A"})

Stressed School Teacher <Stressed School
 
S

Stressed School Teacher

That was really great! Thank you for replying so quickly. I do have one more
question though, how do I do it if the number involved has a percentage sign
with two decimal places after it? is there something different in the lookup
formula that I have to type?

Thanks again,

Adrian Kruse
 
J

JE McGimpsey

Try:

=LOOKUP(A1,{0,"E";0.61,"D";0.71,"C";0.81,"B";0.91,"A"})

Stressed School Teacher
 
S

Stressed School Teacher

You are a legend!

You have just saved hours of work for teachers across our school. Thanks
again!
 
Top