T
Trikester824
That returns different values for a cell that contains a yes, no or N/A.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
N
Niek Otten
=IF(ISNA(A1),3,IF(A1="yes",1,IF(A1="no",2,"something else")))
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
| That returns different values for a cell that contains a yes, no or N/A.
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
| That returns different values for a cell that contains a yes, no or N/A.
D
David Biddulph
=IF(ISNA(A1),"Result for N/A",IF(A1="yes","Result for
yes",IF(A1="no","Result for no","Result for other inputs")))
yes",IF(A1="no","Result for no","Result for other inputs")))
P
PCLIVE
Possibly one way:
=LOOKUP(A1,{"N/A","no","yes"},{"Not Applicable","N","Y"})
=LOOKUP(A1,{"N/A","no","yes"},{"Not Applicable","N","Y"})
O
Otto Moehrbach
If you want to change the contents of a cell based on what is currently in
that same cell, you will need VBA programming. Post back if this is what
you want. HTH Otto
that same cell, you will need VBA programming. Post back if this is what
you want. HTH Otto