Recognize #div/0!

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


--
Message posted via http://www.officekb.com

=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)


"JOn Kunces via OfficeKB.com" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>
> --
> Message posted via http://www.officekb.com