Recognize #div/0!

[JOn Kunces via OfficeKB.com]

i have a formula tha is =IF(AND(-0.04<P3,0.04>P3,Q3=""),13,Q3). I want it to
be able to see if in cell p3 is the error (#Div/0) that it will also insert
the 13 if it follows the criteria set forth able. Thanks

 

[Bob Phillips]

=IF(OR(ISERROR(P3),AND(-0.04<P3,0.04>P3,Q3="")),13,Q3)

--

HTH

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