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().