View Single Post
  #4   Report Post  
 
Posts: n/a
Default

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