How do I create a formula for a blank cell to equal the word NO? Thanks!
D Dave Peterson Sep 26, 2009 #2 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")
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")