How do I indicate a empty or blank cell in an IF function?

F

Formula Dummie

I am trying to do a simple IF function but don't know how to indicate if a
cell is empty or blank then I want a certain text value returned.

What I am trying is:

=IF('Sheet 1'!A15=IS NULL,"NO","YES")

What I want is if the cell indicated on an other sheet is empty or blank
then the word NO to appear in the formula cell and if it does have text then
YES to appear. How can I do this?

Hope I made myself clear enough. I couldn't figure out how to ask help the
right way to get the correct answer.

Thanks for all of your help!
 
F

Formula Dummie

Never Mind. I seem to have gotten it to work using:

=IF('Sheet 1'!A15="","NO","YES")

Thanks again!
 

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

Top