a formula that leaves cell "empty"?

  • Thread starter Thread starter sarahmross
  • Start date Start date
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:
 
Hi there,

Try nesting your Sum formula within an If Formula

=If(Sum(A1:A10)=0,"",Sum(A1:A10))
 
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.
 
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
 
Jason and Ken....

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

Sara
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel formula, sum the value cell and if empty cell left blank 0
Display Empty Cell When Using SUM formula 8
Empty cell in vlookup 9
Adding cells but leaving blank if not populated 1
Leave Cell Blank Continuously 1
How to sum x cells that are greater than zero on the right? 3
Blank cell with average formula 1
How do I write an "if" formula??? See below...... 1

Back
Top