This assumes you placing Y or N in cell a1, copy the line below to the cell
you want YES or No to appear, it cant be the same cell as A1.


=IF(A1="y","Yes",IF(A1="n","No",""))

Alter the a1 to what ever cell you want to look at.
--
This post was created using recycled electrons!


"Rogie" wrote:

I'm trying to have a cell simply input "YES" or "NO" when you type a "Y" or a
"N"...

HELP!