| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
=IF(OR(ISERROR(P3),AND(-0.04<P3,0.04P3,Q3="")),13,Q3)
-- HTH RP (remove nothere from the email address if mailing direct) "JOn Kunces via OfficeKB.com" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to sum cells and ignore the #div/0! 's ? | Excel Worksheet Functions | |||
| How do i make a sum formula ignore #div/0! errors in the range | Excel Worksheet Functions | |||
| replace "#DIV/0!" error with blanks | Excel Worksheet Functions | |||
| # DIV/0! error in Excel | Excel Discussion (Misc queries) | |||
| "Average" with error DIV/0 | Excel Discussion (Misc queries) | |||
Linear Mode
