Convert Text (letter) To Number Excel
 

Hi everyone.
I really need someone to help me out with this basic function:

On microsoft excel, I need a LETTER (ALPHABET) in a cell to be
converted to a numerical value automatically.

EXAMPLE:

WHEN CELL A1 RECIEVES RECIEVES THE LETTER: N, I want that to change (or
another cell to change) to the number 5.

AND WHEN CELL A1 RECIEVES RECIEVES THE LETTER: Y, I want that to change
(or another cell to change) to the number 10.

What do you reckon?

NB: please dont suggest manual things like the find replace, I am to
lazy for that.
I want something really streamlined!!

rish


--
reloadinternet
------------------------------------------------------------------------
reloadinternet's Profile: http://www.excelforum.com/member.php...o&userid=26505
View this thread: http://www.excelforum.com/showthread...hreadid=397745

Use an IF statement, as such:

=IF(A1="Y",10,IF(A1="N",5,""))

Place this formula in the cell of your choice (other than A1, of
course)

HTH

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=397745

One way:

=((A1="N")+2*(A1="Y"))*5

Another:

=SUMPRODUCT(COUNTIF(A1,{"N","Y"}),{5,10})

Another:

=IF(A1="Y",10,IF(A1="N",5,""))



In article
<reloadinternet.1u65ig_1124719796.8862@excelforu m-nospam.com,
reloadinternet
<reloadinternet.1u65ig_1124719796.8862@excelforu m-nospam.com wrote:

Hi everyone.
I really need someone to help me out with this basic function:

On microsoft excel, I need a LETTER (ALPHABET) in a cell to be
converted to a numerical value automatically.

EXAMPLE:

WHEN CELL A1 RECIEVES RECIEVES THE LETTER: N, I want that to change (or
another cell to change) to the number 5.

AND WHEN CELL A1 RECIEVES RECIEVES THE LETTER: Y, I want that to change
(or another cell to change) to the number 10.

What do you reckon?

NB: please dont suggest manual things like the find replace, I am to
lazy for that.
I want something really streamlined!!

rish