school grades in a spreadsheet.
 

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

school grades in a spreadsheet.
 

One way:

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

In article ,
Stressed School Teacher <Stressed School
wrote:

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

school grades in a spreadsheet.
 

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

"JE McGimpsey" wrote:

One way:

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

In article ,
Stressed School Teacher <Stressed School
wrote:

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

school grades in a spreadsheet.
 

Try:

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

In article ,
Stressed School Teacher
wrote:

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

"JE McGimpsey" wrote:

One way:

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

In article ,
Stressed School Teacher <Stressed School
wrote:

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

school grades in a spreadsheet.
 

You are a legend!

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

"JE McGimpsey" wrote:

Try:

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

In article ,
Stressed School Teacher
wrote:

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

"JE McGimpsey" wrote:

One way:

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

In article ,
Stressed School Teacher <Stressed School
wrote:

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