Multiple IF’s with ISERROR

[robertguy]

Hi,

I currently use the following formula using IF and ISERROR i.e.

=IF(ISERROR(IF(O12-(O12/100*80)<S12,"",IF(O12="","","Warning 20% or less Cover Remains!")))," ",(IF(O12-(O12/100*80)<S12,"",IF(O12="","","Warning 20% or less Cover Remains!"))))

What I’m after is to add an addition condition e.g. using “IF(O12-(O12/100*80)<S12” and “IF(O12-(O12/100*90)<S12” which would display either Warning 20% or less Cover Remains! or Warning 10% or less Cover Remains! incorporating ISERROR to avoid #N/A

Any help would be greatly appreciated

Many thanks

Rob

Excel version 2003

[zbor]

First of all, why this would be error?

Not from formula you writed,so if you get O12 as error, can you check that it don't become error?

[zbor]

Second, you don't need two conditions:

“IF(O12-(O12/100*80)<S12” and “IF(O12-(O12/100*90)<S12”

IF(O12-(O12/100*80)<S1 then it's certanly IF(O12-(O12/100*90)<S12


So what you looking for? To be less than 20% or less than 10%?

[zbor]

Third, your formula O12-(O12/100*80) is same as O12(1-80/100) = 0.2*O12

[zbor]

So, in general

IF(O12="","",IF(O12*0.2<S12,"",Warning 20% or less Cover Remains!"))

[robertguy]

Zbor

what I'm after is formula with two If Statements i.e.

IF(O12-(O12/100*80)<S12” OR “IF(O12-(O12/100*90)<S12

then the warning messages would be either “Warning 20% or less Cover Remains!" OR "Warning 10% or less Cover Remains!"

In other words the formula checks if O12 is either 80% or 90% and displays the corresponding warning message.

Ideally I need ISERROR to check if a value #N/A will displayed and enter “ ” instead

I hope this clarifies my requirements


Rob

[zbor]

OK, here:

IF(O12="","",IF(O12*0.1<S12,"",Warning 10% or less Cover Remains!"),IF(O12*0.2<S12,"",Warning 20% or less Cover Remains!"))

[robertguy]

Zbor

unorunatley when I copied in =IF(O12="","",IF(O12*0.1<S12,"",Warning 10% or less Cover Remains!"),IF(O12*0.2<S12,"",Warning 20% or less Cover Remains!")) I get the error message "The formula you typed contained an error" any ideas?


Rob

[zbor]

Can you upload example?

[ConneXionLost]

From zbor's last formula, correcting IF statement structure.

=IF(O12="","",IF(O12*0.1<S12,"Warning 10% or less Cover Remains!",IF(O12*0.2<S12,"Warning 20% or less Cover Remains!","")))

Cheers,

[robertguy]

Zbor & ConneXionLost

Many thanks for your reply and suggestions it is very much appreciated. After some reflection, I released my logic was wrong and I amended my formuas in ConneXionLost code to :-

=IF(O12="","",IF(S12<O12*0.1,"Warning 10% or less Cover Remains!",IF(S12<O12*0.2,"Warning 20% or less Cover Remains!","")))

and it worked as required.

Many thanks again both

Best regards

Rob