BLANK as a Formula result.

[SFP]

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?

 

[kkknie]

I can't think of one, but you could use:

=IF(A1="",TRUE,FALSE)

Rather than =ISBLANK(A1)

 

[Dave Ramage]

In A2:
=A1=""

Cheers,
Dave