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

P

paladin

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.
 
Top