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

Brent wrote:

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

Thanks!

--

Dave Peterson