T Trikester824 Aug 8, 2008 #1 That returns different values for a cell that contains a yes, no or N/A.
N Niek Otten Aug 8, 2008 #2 =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.
=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.
O Otto Moehrbach Aug 8, 2008 #4 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
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
