How do I create a formula

  • Thread starter Thread starter Trikester824
  • Start date Start date
T

Trikester824

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.
 
Possibly one way:

=LOOKUP(A1,{"N/A","no","yes"},{"Not Applicable","N","Y"})
 
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
 
You must log in or register to reply here.

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

match formula 2
Excel formula, sum the value cell and if empty cell left blank 0
Scrabble Value calculation for Welsh words 0
conditional formatting - problem with text cell value from formula 2
#DIV error 2
Too Many IF Statements Nesting Error (Excel Formula Loop w/o VBA) 7
range label works in VLOOKUP except if refenced in another cell 3
If or formula help please 3

Back
Top