Hello,

I have a spreadsheet which has the following in a cell

=IF(D13=0,"",AVERAGE($D$6:D13))

The problem is, D13 has a formula in it. And even though the cell may not be
displaying a value, the formula in the cell is giving me incorrect results
in the above example.

How can I get Excel to ignore the formula and treat the cell as being EMPTY
or equal to 0?

Thanks.