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