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