Creating an "Empty" Cell

[Chuck Schymanski]

I have an IF statement that puts "" in cell based on a
certain condition. But when I go to chart that cell
(along with adjacent cells), that cell gets charted as a
ZERO. I would like it to get charted as an "Empty" cell
which would leave a gap in the line graph. I want the gap
in the line graph indicating that there was no data for
that period. I do NOT want to chart a ZERO.

The question is . . . is there anyway in an IF statement
to say based on a certain condition, make the cell BLANK
or EMPTY (especially if the cell previously had data)?

Thanks.

Chuck

 

[Mark]

Chuck,
I just had this problem yesterday and was given the
following advice. Instead of "" us NA() i.e. =IF(B2 >
5, 'Jun 03'!C72, NA()). This will not enter the value in
the chart. It will fill the cell with "#N/A" which I
removed by changing the font to white and applying
conditional formating to values greater than 0 to make the
font black. Hope this helps.