Excel 2007 : How to hide formula output with no data

[brians34]

I am working on an Excel document for calculating percentage.

Entered =E11/D11 and formatted cell for %

I have a column of 15 rows of these calculations. Not all the calculations are used each time and when there is not data in the cells used in the calculation, the calculated cell shows #DIV/0!

How do I keep the #DIV/0! from showing?

I went to Excel Options > Advanced > and unchecked the "show a zero in cells that have a zero value" under display options and clicked ok, but that didn't work.

[MarvinP]

Hi brians34,

You would put the formula inside an IF function. Something like
=If(IsError(E11/D11),"",E11/D11)
You should also look at the IfError function as it is cleaner in newer versions of Excel.

[brians34]

Thanks Marvin.