I'm trying to have a cell simply input "YES" or "NO" when you type a "Y" or a "N"... HELP!
R Rogie Feb 13, 2007 #1 I'm trying to have a cell simply input "YES" or "NO" when you type a "Y" or a "N"... HELP!
N Newbeetle Feb 13, 2007 #2 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 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.
