Convert Text (letter) To Number Excel

[reloadinternet]

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

 

[swatsp0p]

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

 

[JE McGimpsey]

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,""))



reloadinternet