try

=if(formula=0,NA(),formula)

"Stew Kimble" wrote:

When I plot data I dont want plots to jump to 0 and back where there is
missing data. The data are being created with formulas so I need to find out
how to make a formula result a cleared cell rather than 0