division by zero error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have data where there is a division by zero error because nothing is
entered, but that will change when the data is entered. Is there a way I can
suppress the chart from putting 0's in its place so that there is a gap in
the chart when there is a division by zero error?
 
Try replacing the division formula by something along these lines:
=IF(A1="",NA(),B1/A1)
The chart engine ignores N/A
best wishes
 
Back
Top