1/2 way there. Thank you.

This formula removed the "0" from the spreadsheet, but the "0" is still
graphed as a 0 value in the graph.

I even went back and re-selected the data, saved the file, closed and
reopened.

What next?

Thank you.

"cm" wrote:

change formula to:

=if(INDIRECT("'Enter data'!i$19")=0,"",INDIRECT("'Enter data'!i$19"))



"Mike" wrote:

My formula is:
=INDIRECT("'Enter data'!i$19")

i19 in the "Enter data" sheet referenced in the formula is blank, but the
formula returns a "0" in the cell. I do not want a "0". I just want it
blank. And it is graphing a "0" value when I create a graph based on the
worksheet with the formulas.

Any suggestions on how I can prevent/change this from happening so that the
"0" is not returned or graphed.
Thank you.