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
|