Is this possible?

[jeny04]

I'm working on an admissions spreadsheet and wanted to know if it is possible
to convert a letter to a number in a different cell? Like:

Cell B4= A
I want cell B5 to be 12 (A=12)

Is there any function that does such a thing?

 

[Bill Sharpe]

I'm working on an admissions spreadsheet and wanted to know if it is possible
to convert a letter to a number in a different cell? Like:

Cell B4= A
I want cell B5 to be 12 (A=12)

Is there any function that does such a thing?

VLOOKUP should do the trick. See Excel help for this function.

Bill

 

[Gary''s Student]

=IF(B4="A",12,"")

 

[Harald Staff]

Yes sure. Create a table somewhere with letters in a column and the
corresponding number in the neighbor column to the right. Then create a
VLOOKUP formula in B5 that looks up the B4 letter in the table.
Without knowing your logic ("A=12, and so on") it is hard to be more
spesific, but see Help on VLOOKUP.


HTH. Best wishes Harald

 

[David Biddulph]

=IF(B4="A",12,"whatever you want the answer to be if B4 isn't A")

 

[JLatham]

Another possible solution if you need to make more than just the one decision:

=CHOOSE(FIND(B4,"ABCDEFGHI"),12,13,14,15,16,17,18,19,20)

 

[Rick Rothstein]

Tell us all the letters and their numerical equivalents... perhaps there is
a simple mathematical expression relating the two.