# Convert range of numbers to letter

J

#### JB

Hello.
I hope this makes sense.
I have a spreadsheet that has columns with numbers ranging from 1 to 100.
I would like to convert them to letters
i.e. 90 - 100 = A
80 - 90 = B
70 - 80 = C
60 - 70 = D and so on
Is this possible?
Thank you
JB

M

#### Marcus Fox

JB said:
Hello.
I hope this makes sense.
I have a spreadsheet that has columns with numbers ranging from 1 to 100.
I would like to convert them to letters
i.e. 90 - 100 = A
80 - 90 = B
70 - 80 = C
60 - 70 = D and so on
Is this possible?
Thank you
JB
=IF([cell_value] >= 90, A, IF [cell_value] >= 80, B, IF [cell_value] >= 70,
C, IF [cell_value] >= 60, D, E)

Marcus

M

#### Marcus Fox

Sorry, correction

=IF([cell_value] >= 90, "A", IF [cell_value] >= 80, "B", IF [cell_value] >=
70, "C", IF [cell_value] >= 60, "D", "E")

Marcus

B

#### Bob Phillips

=CHAR(74-MIN(INT((A2-1)/10),9))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

N

#### Niek Otten

Put this in A1:A11:
100
90
80
70
60
50
40
30
20
10
0

And in B1:B11:
A
B
C
D
E
F
G
H
I
J
K

Now, with the value to be looked up in C1:

=MATCH(C1,A1:A11,-1)

Note that you have ambiguous definitions: 80 should be B or C?
Post again if you have problems

A

#### Ardus Petus

=VLOOKUP(A1,{0,"J";10,"I";20,"H";30,"G";40,"F";50,"E";60,"D";70,"C";80,"B";9
0,"A"},2,1)

B

#### bplumhoff

Hello,

=LOOKUP(A74,{0,10,20,30,40,50,60,70,80,90},{"J","I","H","G","F","E","D","C","B","A"})

HTH,
Bernd

A

#### Ardus Petus

You're smarter than I am...

B

#### bplumhoff

Hello Ardus,

Definitely not. We all learn (at least we should, I think) ...

Have fun,
Bernd

J

#### JB

Hi Thank you
Note that you have ambiguous definitions: 80 should be B or C?
You're right! Totally forgot about that.
It would be 91 to 100 and 81 to 90 etc.
I've got to get my head around all these possibilities.
Ta

J

#### JB

Thanks for all your suggestions! It'll take me a while to try them all out.
J