From zbor's last formula, correcting IF statement structure.
Cheers,![]()
=IF(O12="","",IF(O12*0.1<S12,"Warning 10% or less Cover Remains!",IF(O12*0.2<S12,"Warning 20% or less Cover Remains!","")))
From zbor's last formula, correcting IF statement structure.
Cheers,![]()
=IF(O12="","",IF(O12*0.1<S12,"Warning 10% or less Cover Remains!",IF(O12*0.2<S12,"Warning 20% or less Cover Remains!","")))
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
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
Rob
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks