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.