| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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  -- sarahmross ------------------------------------------------------------------------ sarahmross's Profile: http://www.excelforum.com/member.php...o&userid=28725 View this thread: http://www.excelforum.com/showthread...hreadid=484179 |
|
#2
|
|||
|
|||
|
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 -- sarahmross ------------------------------------------------------------------------ sarahmross's Profile: http://www.excelforum.com/member.php...o&userid=28725 View this thread: http://www.excelforum.com/showthread...hreadid=484179 |
|
#3
|
|||
|
|||
|
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 -- sarahmross ------------------------------------------------------------------------ sarahmross's Profile: http://www.excelforum.com/member.php...o&userid=28725 View this thread: http://www.excelforum.com/showthread...hreadid=484179 |
|
#4
|
|||
|
|||
|
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 -- sarahmross ------------------------------------------------------------------------ sarahmross's Profile: http://www.excelforum.com/member.php...o&userid=28725 View this thread: http://www.excelforum.com/showthread...hreadid=484179 |
|
#5
|
|||
|
|||
|
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 |
|
#6
|
|||
|
|||
|
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 |
|
#7
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Any cell containing formula seen as data instead of formula | Excel Worksheet Functions | |||
| Using contents of a cell in a formula | Excel Discussion (Misc queries) | |||
| Can a Formula in Cell X modify Cell Y? | Excel Discussion (Misc queries) | |||
| Cell shows formula and not the result of the formula. | Excel Worksheet Functions | |||
| looking for a formula | Excel Worksheet Functions | |||
Linear Mode
