How do I create a formula

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.
 
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")))
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Newbie Help - IF Yes No Function 0
match formula 2
Excel - Wich Function should I use? 1
#DIV error 2
Converting a number into a cell reference 2
wdActiveEndSectionNumber 1
Help With VLOOKUP 2
Use & with two formulas 2

Top