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!
Bookmarks