Clear a cell from within a formula

[Stew Kimble]

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

 

[Duke Carey]

try

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