Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to insert a formula..but...
How can I insert a formula, say the sum of a column, without the cell showing a zero sum, until the formula has been applied. My form looks messy with all the zero values without any other information in the form. Thanks -- junkmandan ------------------------------------------------------------------------ junkmandan's Profile: http://www.excelforum.com/member.php...o&userid=30866 View this thread: http://www.excelforum.com/showthread...hreadid=505450 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to insert a formula..but...
Change your cell format. The format of a cell is broken down into four
sections, seperated by a semi-colon. The first tells excel what to do with positive numbers. Then negative numbers, THEN ZERO'S, and lastly text. You need to change that third section as follows. For example, $#,##0.00_);[Red]($#,##0.00);"" The double quotes will make them appear blank. "junkmandan" wrote: How can I insert a formula, say the sum of a column, without the cell showing a zero sum, until the formula has been applied. My form looks messy with all the zero values without any other information in the form. Thanks -- junkmandan ------------------------------------------------------------------------ junkmandan's Profile: http://www.excelforum.com/member.php...o&userid=30866 View this thread: http://www.excelforum.com/showthread...hreadid=505450 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to insert a formula..but...
Assuming your range to sum is A1:A10 then =IF(SUM(A1:A10)=0,"",SUM(A1:A10)) This will leave the cell blank until data is entered in the range. Cheers, Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=505450 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to insert a formula..but...
Click on Tools in the menu and click on Options. In the Options dialog box
click on the View tab and locate the Check Box that says Zero Values. The check box is located in the Windows Options panel of the View page. Click this off to have zero values suppressed. -- Kevin Backmann "junkmandan" wrote: How can I insert a formula, say the sum of a column, without the cell showing a zero sum, until the formula has been applied. My form looks messy with all the zero values without any other information in the form. Thanks -- junkmandan ------------------------------------------------------------------------ junkmandan's Profile: http://www.excelforum.com/member.php...o&userid=30866 View this thread: http://www.excelforum.com/showthread...hreadid=505450 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to insert a formula..but...
Maybe ...
=if(counta(a1:a10)<10,"",sum(a1:a10)) It waits until there's something in all 10 cells before doing the sum. Make sure that number matches the number of cells in the range (I used 10 and A1:A10). junkmandan wrote: How can I insert a formula, say the sum of a column, without the cell showing a zero sum, until the formula has been applied. My form looks messy with all the zero values without any other information in the form. Thanks -- junkmandan ------------------------------------------------------------------------ junkmandan's Profile: http://www.excelforum.com/member.php...o&userid=30866 View this thread: http://www.excelforum.com/showthread...hreadid=505450 -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to insert a formula..but...
"Kevin B" wrote in message
... Click on Tools in the menu and click on Options. In the Options dialog box click on the View tab and locate the Check Box that says Zero Values. The check box is located in the Windows Options panel of the View page. Click this off to have zero values suppressed. That might drive him nuts 2 years from now when he *wants* zeros to show on a certain sheet, and doesn't remember having adjusted that option. :-) |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to insert a formula..but...
You might just be right about that...
-- Kevin Backmann "Doug Kanter" wrote: "Kevin B" wrote in message ... Click on Tools in the menu and click on Options. In the Options dialog box click on the View tab and locate the Check Box that says Zero Values. The check box is located in the Windows Options panel of the View page. Click this off to have zero values suppressed. That might drive him nuts 2 years from now when he *wants* zeros to show on a certain sheet, and doesn't remember having adjusted that option. :-) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW DO YOU INSERT A MACRO INTO A FORMULA | Excel Worksheet Functions | |||
how do I insert a row without the formula changing? | Excel Discussion (Misc queries) | |||
How to insert carriage return in the middle of a text formula to . | Excel Discussion (Misc queries) | |||
insert a new cell into an existing formula | Excel Discussion (Misc queries) | |||
How to insert easily the text of a scientific formula | Excel Discussion (Misc queries) |