Quote:
|
Originally Posted by Ewout
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
|
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.