sburgess
04-20-2009, 07:51 AM
I'm trying to supress a #div (divide by zero) error, and I'm using if(iserror(formula), and anything that has a an error, is working good. It brings back a 0 for me. What the problem is, anything that is false (not giving a divide by zero error), is returning a false statement. I need it to calculate the formula that I have in the statement, and return the value, not "false".
Any help on this, as this is the first time I have used the (iserror) in a formula?
Here is the if statement that I'm using...
=IF(ISERROR(IF('MSO PR'!Z14=0,0,(IF('MSO PR'!AB14<>0,'MSO PR'!AB14-'MSO PR'!Z14,0)))/'MSO PR'!Z14),0)
A suggestion was to include another if statement at the beginning, using the Iserror as the "true" statement, and the rest of the formula as the "false",
so it would be something like this -
=if('mso pr'!ab14=0,(IF(ISERROR(IF('MSO PR'!Z14=0,0,(IF('MSO PR'!AB14<>0,'MSO PR'!AB14-'MSO PR'!Z14,0)))/'MSO PR'!Z14),0)))
I know that I'm probably way off, but this is what I need it to do. Any help would be great!
:banghead: :motz2:
Any help on this, as this is the first time I have used the (iserror) in a formula?
Here is the if statement that I'm using...
=IF(ISERROR(IF('MSO PR'!Z14=0,0,(IF('MSO PR'!AB14<>0,'MSO PR'!AB14-'MSO PR'!Z14,0)))/'MSO PR'!Z14),0)
A suggestion was to include another if statement at the beginning, using the Iserror as the "true" statement, and the rest of the formula as the "false",
so it would be something like this -
=if('mso pr'!ab14=0,(IF(ISERROR(IF('MSO PR'!Z14=0,0,(IF('MSO PR'!AB14<>0,'MSO PR'!AB14-'MSO PR'!Z14,0)))/'MSO PR'!Z14),0)))
I know that I'm probably way off, but this is what I need it to do. Any help would be great!
:banghead: :motz2: