a formula that leaves cell "empty"?
 

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:


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

a formula that leaves cell "empty"?
 

=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" wrote
in message ...

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:


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

a formula that leaves cell "empty"?
 

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" wrote
in message ...

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:


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

a formula that leaves cell "empty"?
 

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
:confused:


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

a formula that leaves cell "empty"?
 

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

a formula that leaves cell "empty"?
 

Jason and Ken....

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

Sarah


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

a formula that leaves cell "empty"?
 

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

"sarahmross" wrote
in message ...

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