Formula to return a blank cell that won't be plotted as zero

[Guest]

Using Excel 2000 I want to enter an "if" formula that returns a blank cell
when satisfied that won't be plotted as zero on a line or xy plot. The zero
text string "" always plots as a zero.

 

[Frank Kabel]

Hi
return
NA()
instead of an empty cell