Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HOW DO MAKE ZEROES DISAPPEAR WHEN THERE ARE NO NUMBERS TO SUM
I have formatted multiple cells to SUM when the appropriate data is input.
But until that data is input, it puts a 0(zero) in the cell. Is there any way to make the cells blank until actual data is input without clearing the cell of the SUM command? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
HOW DO MAKE ZEROES DISAPPEAR WHEN THERE ARE NO NUMBERS TO SUM
Tazman,
I don't know if this is exactly what you're looking for, but try setting conditional formatting on the cells. Mark "tazman2168" wrote: I have formatted multiple cells to SUM when the appropriate data is input. But until that data is input, it puts a 0(zero) in the cell. Is there any way to make the cells blank until actual data is input without clearing the cell of the SUM command? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
HOW DO MAKE ZEROES DISAPPEAR WHEN THERE ARE NO NUMBERS TO SUM
something like
=if(sum(a23:a45)=0,"",sum(a23:a45)) -- Greetings from New Zealand Bill K "tazman2168" wrote in message ... I have formatted multiple cells to SUM when the appropriate data is input. But until that data is input, it puts a 0(zero) in the cell. Is there any way to make the cells blank until actual data is input without clearing the cell of the SUM command? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
HOW DO MAKE ZEROES DISAPPEAR WHEN THERE ARE NO NUMBERS TO SUM
Either test for zero value then place a null in the cell if true or the sum
if false =IF(SUM(A1:A10)=0,"",SUM(A1:A10)) or remove all zeros from the sheet by clicking ToolsOptionsView and uncheck Zero Values "tazman2168" wrote: I have formatted multiple cells to SUM when the appropriate data is input. But until that data is input, it puts a 0(zero) in the cell. Is there any way to make the cells blank until actual data is input without clearing the cell of the SUM command? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
HOW DO MAKE ZEROES DISAPPEAR WHEN THERE ARE NO NUMBERS TO SUM
tools/options uncheck the zero values option
-- Gary "tazman2168" wrote in message ... I have formatted multiple cells to SUM when the appropriate data is input. But until that data is input, it puts a 0(zero) in the cell. Is there any way to make the cells blank until actual data is input without clearing the cell of the SUM command? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
HOW DO MAKE ZEROES DISAPPEAR WHEN THERE ARE NO NUMBERS TO SUM
Is there a difference between no cells to sum and cells with zero,
and cells that sum to zero. from previous example: =if(sum(a23:a45)=0,"",sum(a23:a45)) =IF(Count(A23:a45)0,Sum(A23:a45),"") would show the zero if the actual sum is zero, but an empty string if there were no numeric values in the range. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "tazman2168" wrote in message ... I have formatted multiple cells to SUM when the appropriate data is input. But until that data is input, it puts a 0(zero) in the cell. Is there any way to make the cells blank until actual data is input without clearing the cell of the SUM command? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to make a form self disappear | Excel Programming | |||
How to make excel disappear! | Excel Discussion (Misc queries) | |||
How do I make it disappear? | New Users to Excel | |||
Make a button disappear | Excel Programming | |||
how to make dropdown arrow disappear in vba | Excel Worksheet Functions |