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?

jeny04 wrote:
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

=IF(B4="A",12,"")
--
Gary''s Student - gsnu200847

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

"jeny04" wrote in message
...
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?

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


"jeny04" wrote in message
...
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?

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)

"jeny04" wrote:

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?

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

--
Rick (MVP - Excel)


"jeny04" wrote in message
...
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?