#DIV/0
 

How can you override a DIV/O error in a master sheet to come up as just a 0?

Presumably the #DIV/0 is a result of a formula. The solution is to test the
divisor for 0, and if so take one course, else effect the formula.

As an example

=IF(A2=0,0,A1/A2)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Todd Nelson" wrote in message
...
How can you override a DIV/O error in a master sheet to come up as just a
0?