How do I create a formula
 

That returns different values for a cell that contains a yes, no or N/A.

How do I create a formula
 

=IF(ISNA(A1),3,IF(A1="yes",1,IF(A1="no",2,"somethi ng else")))

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Trikester824" wrote in message
...
| That returns different values for a cell that contains a yes, no or N/A.

How do I create a formula
 

=IF(ISNA(A1),"Result for N/A",IF(A1="yes","Result for
yes",IF(A1="no","Result for no","Result for other inputs")))
--
David Biddulph

"Trikester824" wrote in message
...
That returns different values for a cell that contains a yes, no or N/A.

How do I create a formula
 

Possibly one way:

=LOOKUP(A1,{"N/A","no","yes"},{"Not Applicable","N","Y"})

--

"Trikester824" wrote in message
...
That returns different values for a cell that contains a yes, no or N/A.

How do I create a formula
 

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
"Trikester824" wrote in message
...
That returns different values for a cell that contains a yes, no or N/A.