#DIV/0

T

Todd Nelson

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

Bob Phillips

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 said:
How can you override a DIV/O error in a master sheet to come up as just a
0?
 
Top