global excel worksheet formula

In Excel, is there a way to create a global worksheet formula that encompasses the whole worksheet for the function =If(denominator=0,"",numerator/denominator)?

Essentially, I have a larg开发者_如何学运维e worksheet that is returning #DIV/0! in many of my cells. I want the result to return zero or blank.

---

As far as i know, you cannot intercept standard calculation in Excel formula (if someone does, please tell us :)).

You can use another Worksheet to display the results by checking if your cell has an error with formulas like ISERROR()

---

In Excel 2007 onward, there is also the function IFERROR. You could try

=IFERROR(numerator/denominator,"")