How do I enter a formula in a cell so that letters= a number i.e..
 

How do I enter a formula in a cell so that letters= a number i.e Y=5, N=2.

Try this.
Change 'cell_ref' to the cell with a letter in.
=If(cell_ref="Y",5,If(cell_ref="N",2,""))

"Alex" wrote:

How do I enter a formula in a cell so that letters= a number i.e Y=5, N=2.

See one response in your identical post in .newusers
(Please do not multi-post)
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Alex" wrote in message
...
How do I enter a formula in a cell so that letters= a number i.e Y=5, N=2.