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