View Single Post
  #6   Report Post  
Anne Troy
 
Posts: n/a
Default

No. There's really no way to have Excel see a blank cell when it contains a
formula...
************
Anne Troy
www.OfficeArticles.com

wrote in message
oups.com...
Anne Troy wrote:
If(a10,a1*4,"")
But Excel will not consider the cell to truly be blank...


Precisely! And there are circumstances where that makes a
difference. I cannot think of an example off-hand, but I
stumble across them "all the time".

So, is there a way to get a "truly" blank cell (i.e, the
functional equivalent)?

It would be nice if there were a function called BLANKCELL().