Blank Cell/IF Problem

[N.Cassadine]

Hello,

I have a spreadsheet which has the following in a cell

=IF(D13=0,"",AVERAGE($D$613))

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.

 

[Max]

Try adding an additional check for D13="", viz:
=IF(OR(D13=0,D13=""),"",AVERAGE($D$613))

 

[Ron Rosenfeld]

Hello,

I have a spreadsheet which has the following in a cell

=IF(D13=0,"",AVERAGE($D$613))

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.

What is the formula in D13?

You should be checking for the value that the formula gives when you want excel
to execute the condition_true portion of the IF statement.
--ron