I'm not sure it your Charts will see this as 0 or as not for error
conditions, but give this a try. Use this formula in the cell...

=IF(ISERR(YourFormula),"",YourFormula)

and use this Custom Format on that cell....

0.0#;-0.0#;0;--"0"

Obviously, change the format pattern for positive and negative values to
what you actually need.

Rick


wrote in message
...
Because it then show up on the chart. I forgot to mention that the
chart is set up so the horizontal access crosses at a non zero number.
Sorry for the incomplete question.

On Jan 21, 11:00 am, "Rick Rothstein \(MVP - VB\)"
wrote:
Unfortunately I'm creating this for someone that wants the
cells to show a 0 "zero" not a "blank" or a "#N/A"

Why can't you do it this way then?

=IF(ISERR(YourFormula),0,YourFormula)

Rick