How do you make a cell empty using an "if" statement in that same cell?
We are plotting these cells in a chart. Right now the "if" statement places a zero length string in the cell and the chart plots a zero value. We want the chart to plot nothing for this cell. The chart will plot nothing if the cell is empty.
Code example
=IF(A57<=NOW(),G57,"")
How can I get around this issue?
We are plotting these cells in a chart. Right now the "if" statement places a zero length string in the cell and the chart plots a zero value. We want the chart to plot nothing for this cell. The chart will plot nothing if the cell is empty.
Code example
=IF(A57<=NOW(),G57,"")
How can I get around this issue?