blank cell until after formula applied
"junkmandan" wrote
in message ...
How can I insert a simple sum formula without a "0" appearing in the
cell until the formula has been applied. Thanks
By the way, in my example and Chuck's the formulae translate easily into
words:
=IF($A14=0,"",$A14*G14)
If A14 is zero
THEN put nothing in this cell (quotation marks with nothing between them).
ELSE (A14 isn't blank)
Multiply A14 by G14
You don't have to leave the cell empty - you could also put some sort of
text between the quotes.
|