Empty Cells

[jandrews]

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?

 

[Aladin Akyurek]

Try returning #N/A instead of "" :

=IF(A57<=NOW(),G57,NA())

If desired, you can cond format #N/A's white.

 

[jandrews]

Thanks Aladin It worked.