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



--
sarahmross
------------------------------------------------------------------------
sarahmross's Profile: http://www.excelforum.com/member.php...o&userid=28725
View this thread: http://www.excelforum.com/showthread...hreadid=484179

=if(isblank(a1),"",sum(a1:a5)) or perhaps =if(sum(a1:a5)=0,"",sum(a1:a5)

************
Anne Troy
VBA Project Manager
www.OfficeArticles.com

"sarahmross" <(E-Mail Removed)> wrote
in message news:(E-Mail Removed)...
>
> 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
>
>
>
> --
> sarahmross
> ------------------------------------------------------------------------
> sarahmross's Profile:
> http://www.excelforum.com/member.php...o&userid=28725
> View this thread: http://www.excelforum.com/showthread...hreadid=484179
>

Hi there,

Try nesting your Sum formula within an If Formula

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

--
Ken Puls
www.officearticles.com


"sarahmross" <(E-Mail Removed)> wrote
in message news:(E-Mail Removed)...
>
> 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
>
>
>
> --
> sarahmross
> ------------------------------------------------------------------------
> sarahmross's Profile:
> http://www.excelforum.com/member.php...o&userid=28725
> View this thread: http://www.excelforum.com/showthread...hreadid=484179
>

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.


"sarahmross" wrote:

>
> 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
>
>
>
> --
> sarahmross
> ------------------------------------------------------------------------
> sarahmross's Profile: http://www.excelforum.com/member.php...o&userid=28725
> View this thread: http://www.excelforum.com/showthread...hreadid=484179
>
>

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


--
sarahmross
------------------------------------------------------------------------
sarahmross's Profile: http://www.excelforum.com/member.php...o&userid=28725
View this thread: http://www.excelforum.com/showthread...hreadid=484179

Jason and Ken....

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

Sara

--
sarahmros
-----------------------------------------------------------------------
sarahmross's Profile: http://www.excelforum.com/member.php...fo&userid=2872
View this thread: http://www.excelforum.com/showthread.php?threadid=48417

You're welcome, Sarah!
************
Anne Troy
VBA Project Manager
www.OfficeArticles.com

"sarahmross" <(E-Mail Removed)> wrote
in message news:(E-Mail Removed)...
>
> 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
>
>
> --
> sarahmross
> ------------------------------------------------------------------------
> sarahmross's Profile:
> http://www.excelforum.com/member.php...o&userid=28725
> View this thread: http://www.excelforum.com/showthread...hreadid=484179
>