iserror help

[milehigh]

Hi all,

I am trying to eliminate the Div/9 error that I get

my formula is the following:

=IF(OR(AND(D30>=0.2),AND(D28=0,E28>0)),"PD",IF(AND
(D30="PD",E28>0),"PD",(E28-MIN($C$2828))/MIN($C$2828)

I tried using iserror in the following manner:

=if(iserror(IF(OR(AND(D30>=0.2),AND(D28=0,E28>0)),"PD",IF
(AND(D30="PD",E28>0),"PD",(E28-MIN($C$2828))/MIN
($C$2828))),0,IF(OR(AND(D30>=0.2),AND
(D28=0,E28>0)),"PD",IF(AND(D30="PD",E28>0),"PD",(E28-MIN
($C$2828))/MIN($C$2828)))

but it keeps giving me an error (that the formula is not
correct).

I just want to display a zero when my formula divides by
zero.... Thanks in advance.

 

[Frank Kabel]

Hi all,

I am trying to eliminate the Div/9 error that I get

my formula is the following:

=IF(OR(AND(D30>=0.2),AND(D28=0,E28>0)),"PD",IF(AND
(D30="PD",E28>0),"PD",(E28-MIN($C$2828))/MIN($C$2828)

Hi
try
=IF(OR(AND(D30>=0.2),AND(D28=0,E28>0)),"PD",IF(AND(D30="PD",E28>0),"PD"
,IF(MIN($C$2828)<>0,(E28-MIN($C$2828))/MIN($C$2828),0)))

Frank

 

[Bob Phillips]

Just test the error condition, like so

=IF(MIN($C$2828)=0,0,IF(OR(AND(D30>=0.2),AND(D28=0,E28>0)),"PD",IF(AND(D30
="PD",E28>0),"PD",(E28-MIN($C$2828))/MIN($C$2828))))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)