BLANK as a Formula result.
In A2:
=A1=""
Cheers,
Dave
-----Original Message-----
Does Excel have a way to produce a cell that it recognizes
as BLANK as a result of a formula?
="" works to clear the display, but it reads FALSE on an
ISBLANK() test. For example...
in cell A1: =IF(TRUE,"",1)
in cell A2: =ISBLANK(A1)
Cell A2 will return FALSE in this example. Is there any
way to change the "" in cell A1 so that cell A2 will
return
TRUE?
.
|