a formula that leaves cell "empty"?

S

sarahmross

Is there such a formula that will leave a cell empty? Example: I use
the formula SUM(...) to add up orders...but, if there are no orders in
that category, then the cell will have the value of "0.0". Is there
any way to leave the cell blank (with the formula still in there) when
there are no orders? I really need help on this, it's driving me
mad!!! Any help would be sweet.

Thanks! -Sarah
:confused:
 
K

Ken Puls

Hi there,

Try nesting your Sum formula within an If Formula

=If(Sum(A1:A10)=0,"",Sum(A1:A10))
 
J

Jason Clement

You can also specify a custom format in your number format, using your
example I'm assuming your showin 1 decimal place:

Click Format->Cells
On the Number tab click Custom.
In the box at the top of the list type -> 0.0;-0.0;;@
This will make the cell blank when the value is 0.
 
S

sarahmross

Anne,

Thank you so much!! The second formula worked for me,
the =IF(SUM(C1:C5)=0,"",SUM(C1:C5)). It did what was needed, entered
nothing in the cell, and still kept the sum formula....

Hats off to you, thank you once again!

Sarah
 
S

sarahmross

Jason and Ken....

Thanks for the extra tips...this is really appreciated guys, thanks S
much....

Sara
 
Top