IF formulas creates zeros in a line graph

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

Guest

When Using an =IF(,,) function like =IF(A1="","",A1-A2) if A1 is blank Excel
still shows a zero in the graphs even when show blanks as zero option is not
selected. Any way to fix this?
 
You could replace your "" with N/A() this is not plotted

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
Back
Top