Blank Cell/IF Problem

N

N.Cassadine

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.
 
M

Max

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

Ron Rosenfeld

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.
Click to expand...

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
 
Top