Hi Mike,

"Mike H" wrote in message
...
It literally means nothing

=IF(A1=""," It's empty","data found")

So the above formula looks if A1="" i.e. nothing
and if that true returns 'It's empty".

This isn't quite correct. In actual fact "" doesn't mean Empty at all, it
just looks like empty. A cell is only empty if it literally contains
nothing - neither constants nor formulae.

Regards
--
KL
[MVP - Microsoft Excel]
RU: http://www.mvps.ru/Program/Default.aspx
ES: http://mvp.support.microsoft.com/?LN=es-es
EN: http://mvp.support.microsoft.com/?LN=en-us
Profile: http://mvp.support.microsoft.com/profile/Kirill