It is called the null string, a string of zero characters. It is useful for
making a cell look blank, particularly under some conditions.
It is important to note that a cell with the value of the null string does
not behave the same in some contexts as an empty cell.
For example, if A1 has the formula =IF(B1<=0,"",B1) and A2 has the formula
=A1+B2, A2 returns a #VALUE error because we trying to add non-numeric text
to B2 (if B1<=0).
Some ways to correct that:
=IF(A1="",B2,A1+B2)
=N(A1)+B2
Both treat A1 with the null string value the same as empty A1, namely zero.
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.