Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell with zero to appear as empty
Is it possible in Excel 2003 to make a cell with a formula, that has the
outcome zero, to appear as an empty cell? I am making a line graphic but I want the cells with zero not added in the graphic. How is this possible? -- Ewout |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell with zero to appear as empty
ToolsOptionsView uncheck Zero values.
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Ewout" wrote in message ... Is it possible in Excel 2003 to make a cell with a formula, that has the outcome zero, to appear as an empty cell? I am making a line graphic but I want the cells with zero not added in the graphic. How is this possible? -- Ewout |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell with zero to appear as empty
Change your formulas to return the #N/A error instead of 0, which XL will
not graph. =IF(SUM(A1:A20),SUM(A1:A20),#N/A) =IF(A20*A10,A20*A10,#N/A) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Ewout" wrote in message ... Is it possible in Excel 2003 to make a cell with a formula, that has the outcome zero, to appear as an empty cell? I am making a line graphic but I want the cells with zero not added in the graphic. How is this possible? -- Ewout |
#4
|
|||
|
|||
Quote:
here is another way to do this for example in column a you have jobs estimated and column b you have number of men working and column c would be the total hours worked (column a * column b) hide column c and use column d for the totals put this formula in column d =if(c1=0,"",c1) this will only show a value in d1. if b*a = 0 then nothing shows up in d. i hope this helps. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell with zero to appear as empty
Thanks, that was just the answer I was looking for!
-- Ewout "RagDyer" wrote: Change your formulas to return the #N/A error instead of 0, which XL will not graph. =IF(SUM(A1:A20),SUM(A1:A20),#N/A) =IF(A20*A10,A20*A10,#N/A) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Ewout" wrote in message ... Is it possible in Excel 2003 to make a cell with a formula, that has the outcome zero, to appear as an empty cell? I am making a line graphic but I want the cells with zero not added in the graphic. How is this possible? -- Ewout |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell with zero to appear as empty
Thanks for the feed-back.
-- Regards, RD ---------------------------------------------------------------------------- ------------------- Please keep all correspondence within the Group, so all may benefit ! ---------------------------------------------------------------------------- ------------------- "Ewout" wrote in message ... Thanks, that was just the answer I was looking for! -- Ewout "RagDyer" wrote: Change your formulas to return the #N/A error instead of 0, which XL will not graph. =IF(SUM(A1:A20),SUM(A1:A20),#N/A) =IF(A20*A10,A20*A10,#N/A) -- HTH, RD -------------------------------------------------------------------------- - Please keep all correspondence within the NewsGroup, so all may benefit ! -------------------------------------------------------------------------- - "Ewout" wrote in message ... Is it possible in Excel 2003 to make a cell with a formula, that has the outcome zero, to appear as an empty cell? I am making a line graphic but I want the cells with zero not added in the graphic. How is this possible? -- Ewout |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell with zero to appear as empty
Dear Bob,
Was already aware of that option, but then zero still appears in a graphic. The answer of RagDyer gave me what I needed. Thanks for the effort, though! -- Ewout "Bob Phillips" wrote: ToolsOptionsView uncheck Zero values. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Ewout" wrote in message ... Is it possible in Excel 2003 to make a cell with a formula, that has the outcome zero, to appear as an empty cell? I am making a line graphic but I want the cells with zero not added in the graphic. How is this possible? -- Ewout |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
insert date | Excel Worksheet Functions | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Leaving an empty cell empty | Excel Discussion (Misc queries) | |||
make a cell empty based on condition | Charts and Charting in Excel | |||
GET.CELL | Excel Worksheet Functions |