ExcelBanter - Clear a cell from within a formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Clear a cell from within a formula (https://www.excelbanter.com/excel-worksheet-functions/132816-clear-cell-within-formula.html)

Stew Kimble

Clear a cell from within a formula

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

Clear a cell from within a formula

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

All times are GMT +1. The time now is 03:21 AM.