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
 
Ad

Advertisements

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)
 
Ad

Advertisements

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
 
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
 
Ad

Advertisements

J

JB

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

Advertisements


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

Top