BLANK as a Formula result.
 

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?

BLANK as a Formula result.
 

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

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

Rather than =ISBLANK(A1)



--
Message posted from http://www.ExcelForum.com

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?
.