Excel Formula

  • Thread starter Thread starter Brent
  • Start date Start date
B

Brent

How do I create a formula for a blank cell to equal the word NO?

Thanks!
 
So if A1 is the cell, then an empty cell or No means No?

=if(or(a1="",a1="no"),"it's equivalent to no","it's something else")
 
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

Formula with blanks 5
If condition with text 3
Excel Inequalities: "<>" vs "><" 0
Help needed 0
Help with this formula 3
Excel Need Countifs Formula Help 0
Finding Text within an Array 2
Excel 2003 Calculation Problems 9

Back
Top