C
clueless
Can anyone help?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Mike H
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".
Mike
=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".
Mike
K
KL
clueless said:Can anyone help?
It means: text string of zero-length. In the formulae it is typically used
to emulate empty cells (although it is not quite the same) , e.g.
=IF(A1>0,A1,""), or to convert a value to text, e.g. =A1&""
--
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
K
KL
Hi Mike,
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
Mike H said: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