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