blank cell until after formula applied

J

junkmandan

How can I insert a simple sum formula without a "0" appearing in th
cell until the formula has been applied. Thank
 
S

S3NTYN3L

I'm not sure exactly what your meaning by "until the formula has been
applied" but...

Have you tried the SUMIF function?

Look it up in Help for examples of its useage.

Hope this helps...
 
C

CLR

=IF(SUM(A1,A2)=0,"",SUM(A1,A2))

There are other ways also, depending on exactly what you want.

Vaya con Dios,
Chuck, CABGx3
 
D

Doug Kanter

junkmandan said:
How can I insert a simple sum formula without a "0" appearing in the
cell until the formula has been applied. Thanks
Click to expand...

Here's an example from one of my sheets:
=IF($A14=0,"",$A14*G14)

Try constructing something similar, and pay attention to the commas.

Another option is to use the ISBLANK function, which tests to see if a
certain cell is blank. Start Excel's help system and search for ISBLANK.
 
D

Doug Kanter

junkmandan said:
How can I insert a simple sum formula without a "0" appearing in the
cell until the formula has been applied. Thanks
Click to expand...

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.
 
Top