Convert range of numbers to letter

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

"JB" <badspam@awyway.com> wrote in message
news:OUlxDBVPGHA.3728@tk2msftngp13.phx.gbl...
> 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

"Marcus Fox" <please-reply-via-newsgroup-th@-i-posted-to.com> wrote in
message news:aIkNf.54422$494.14199@newsfe2-gui.ntli.net...
>
> "JB" <badspam@awyway.com> wrote in message
> news:OUlxDBVPGHA.3728@tk2msftngp13.phx.gbl...
> > 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

Sorry, correction

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

Marcus

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"JB" <badspam@awyway.com> wrote in message
news:OUlxDBVPGHA.3728@tk2msftngp13.phx.gbl...
> 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
>
>

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

--
Kind regards,

Niek Otten

"JB" <badspam@awyway.com> wrote in message
news:OUlxDBVPGHA.3728@tk2msftngp13.phx.gbl...
> 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
>
>

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


"Niek Otten" <nicolaus@xs4all.nl> wrote in message
news:e%23fCHZVPGHA.2668@tk2msftngp13.phx.gbl...
> 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
>
> --
> Kind regards,
>
> Niek Otten
>
> "JB" <badspam@awyway.com> wrote in message
> news:OUlxDBVPGHA.3728@tk2msftngp13.phx.gbl...
>> 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
>>
>>
>
>

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

--
AP

"JB" <badspam@awyway.com> a écrit dans le message de
news:OUlxDBVPGHA.3728@tk2msftngp13.phx.gbl...
> 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
>
>

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

You're smarter than I am...

--
AP

<bplumhoff@gmail.com> a écrit dans le message de
news:1141236395.329964.119140@p10g2000cwp.googlegroups.com...
> 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
>

Hello Ardus,

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

Have fun,
Bernd

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

"JB" <badspam@awyway.com> wrote in message
news:OUlxDBVPGHA.3728@tk2msftngp13.phx.gbl...
> 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
>
>