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,"")