If Then Statement...question

[krehkop]

Let's say I have =if(a1="","Yes","")

How would I change the "" to recognize something other than nothing? Is there something that I can type into my formula that identifies something (anything), regardless of what it is, rather than nothnig?

So if a1 recognizes something (anything other than a blank), then "Yes", otherwise "".

Let's pretend that this magical thing that recognizes something rather than nothing is a question mark, I would want my formula to look like the following: =if(a1=?,"Yes","").

Thanks to all!

 

[brian.wethington]

=if(a1<>"","Yes","")

 

[Scott Huish]

In your original formula, you had:

=IF(A1="","Yes","")

This put Yes when A1 was blank, moving the YES to the FALSE position would show YES when it is not blank:

=IF(A1="","","Yes")

brian.wethington's works too, but he uses the symbol for not equal <>
=IF(A1<>"","Yes","")