Empty Cells

jandrews · Feb 22nd, 2002, 12:04 PM

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 · Feb 22nd, 2002, 12:12 PM

Try returning #N/A instead of "" :

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

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

jandrews · Feb 22nd, 2002, 12:14 PM

Thanks Aladin It worked.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 22nd, 2002, 12:04 PM	#1
jandrews New Member Join Date: Feb 2002 Posts: 2	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?

Feb 22nd, 2002, 12:12 PM	#2
Aladin Akyurek MrExcel MVP Join Date: Feb 2002 Location: The Hague Posts: 50,314	Try returning #N/A instead of "" : =IF(A57<=NOW(),G57,NA()) If desired, you can cond format #N/A's white.

Feb 22nd, 2002, 12:14 PM	#3
jandrews New Member Join Date: Feb 2002 Posts: 2	Thanks Aladin It worked.