Formula to delete values in cells if value=0

[adityatandel]

Is there a formula which will delete the value in a cell if the value is 0? i need these values to create a chart and even if there is nothing visible in the cell, the chart takes the formula as zero. what i need is the formula in the cell to be deleted completely.

-Aditya

 

[VoG]

Another approach with your chart selected is Tools > Options > Chart and select the option not to plot zero values.

Yet another option is to get your formula to return NA() instead of zero.

Otherwise I'm pretty sure you would need some VBA code to do this.

 

[Datsmart]

In chart source range, set zero's to show NA() instead of "" or 0.
You will see N/A# in your table but they will not show or plot in your chart.

Use a formula similar to this…
=IF(C3=0,NA(),C3)

 

[adityatandel]

Thanks guys. The NA() formula works.

-Adi