Formulas that give a blank result graph as zero, want a gap in the graph instead.

I have a formula that determines if there are values in two cells. If values are present, then a function is performed to calculate a number. If one or both cells are blank, then it returns a "blank" in the cell.

=IF(COUNT(B2, C2)=2, B2*C2/100*1000000*8.34, " ")

When the column is graphed, all the " " cells graph as zero. I would like the graph to shows gaps in the data. I've tried "showing hidden and empty cells as gaps", but since technically the cell has a formula in it, it is not empty.

Is there a way to show the " " (blank) cells as gaps, or am I stuck if there is a formula in the cell? Do I have to actually delete the formula in the cells in order for there to be gaps in the graph.

Thank you!

Changing it from " " to "" didn't make a difference. Nice try.

I can apply a filter only showing those numbers >0, but the spreadsheet columns spread A-N, and I lose data in other columns I need for other graphs. If I use "filter", I'll can copy the same data to another spreadsheet for the one graph.

If no one comes up with a better solution, I can use the filter function.

The linked article in the previous post was very helpful.

The formula I ended up using is ... =IF(COUNT(B2, C2)=2, B2*C2/100*1000000*8.34, NA())

The line connects but there is no data marker at the points where there is no data.

Thank you!