View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SFP SFP is offline
external usenet poster
 
Posts: 1
Default 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?