Value of ""

T

TinMan

This seems too simple, but what is the value of "" (empty quotes) when
checking it against an if statement.

If one cell returns "", it has a value, but I can't figure it out. I need to
know how to reference this cell on another sheet to determine what to
respond with. Right now my second cell has an if blank, or an if 0, but
there is a formula in the cell, so both of these return true.

I'm not even explaining this well, but I think you get the idea. How to
return a true value from a cell that is returning "".

Thanks,
 

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