View Single Post
  #1   Report Post  
JOn Kunces via OfficeKB.com
 
Posts: n/a
Default Recognize #div/0!

i have a formula tha is =IF(AND(-0.04<P3,0.04P3,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