Excel Formula

[Brent]

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

Thanks!

 

[Dave Peterson]

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