IF statement not returning a blank so a chart line won't gap

[mikekaf]

I have an IF formula that should return a blank to a cell using the "". but
the chart does not recognize it as a blank and drops the shart line to zero
instead of showing a gap

 

[David Biddulph]

Replace the "" in your formula by NA()

 

[JC]

I have an IF formula that should return a blank to a cell using the "". but
the chart does not recognize it as a blank and drops the shart line to zero
instead of showing a gap

The chart interprets "" as 0 so if you replace the "" with NA() in your
IF formula your chart will show the gap correctly.

 

[Jon Peltier]

The chart will not show a gap. It will omit a marker at this X value, but if
the markers are connected with lines, the line will connect the points on
either side of the missing marker.

- Jon