Divide By Zero

[estone4009]

I'm wanting to prefill a sheet with the formulas needed so that a user only has to enter two values and print the results. But I can not fill the formula down or I get #DIV/0 errors and they print on the sheet. How can I have these formulas pre filled down but hide the Divide By zero error until data is entered?

 

[bluedragon2]

use an IF statement in the formula to check for ISERROR:

ex.

=IF(ISERROR(A1/A2),"",A1/A2)

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[dhulbert]

estone

Cange the formula so that it reads

if(iserror(your formula),0,(your formula))

That way if the formula returns an error the cell will display 0 other wise it displays the correct value.
You can make things look tidier using the Tools-Options and on the View tab unselecting Zero Values.

 

[coachdan]

bluedragon's formula would be better, the zero's would skew any kind of averages you might be using on the sheet.

coachdan32