I have a chart that is using numbers on a sheet. One of the columns
has a conditional formula in it that returns either a number or #N/A
using to avoid a divide by zero error. I using the formula N/A() if
the IF Statement formula would be divisible by Zero. I want this
because I don't want the chart to show a value that meets this
condition.

I would like to format the sheet using custom number formating to show
a 0 "zero" instead of #N/A. However I can't figure out how to use the
[Conditional] to work with the #N/A that is returned. I have tried
[=#N/A] 0.00 but excel changes this to [=0] 0.00 when I enter press
ok. Is there any way that this can be accomplished using custom number
formating?

Appreciate any help.