Try adding an additional check for D13="", viz:
=IF(OR(D13=0,D13=""),"",AVERAGE($D$6:D13))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"N.Cassadine" wrote in message
...
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.