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.