return a blank cell

  • Thread starter Thread starter jpotts8117
  • Start date Start date
J

jpotts8117

I would like to acheive a blank cell if it meets the qualification:

if the contents of the cell is greater than zero then mulitiply the
contents by 4; if the cell is empty then return an empty cell (not
0.0)

can it be done?
 
Anne said:
If(a1>0,a1*4,"")
But Excel will not consider the cell to truly be blank...
Click to expand...

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