Recognize #div/0!

  • Thread starter Thread starter JOn Kunces via OfficeKB.com
  • Start date Start date
J

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