Is this possible?
 

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?

Is this possible?
 

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

Is this possible?
 

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

Is this possible?
 

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?

Is this possible?
 

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

Is this possible?
 

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?

Is this possible?
 

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?