IF Formula

HZAR · 05/14/24

I have one question. I have the formula below

=IF([GSP Status]@row = "Cancel", "NO", IF([MSI Proposed Settlement ($USD)]@row >= {Buyer Supervisor Limit}, "YES", IF([MSI Proposed Settlement ($USD)]@row = "", "TBD","NO"))))

The condition that I want as below

1)If the status is cancel -Required approval=No

2) If the status is under all condition and buyer email is CC@gmail and CW@gmail-Required Approval=No

How do I change my formula above to meet the requirement of 1 & 2? Coz if based on formula above when it cancel status only will trigger the Required approval=No

jcaguioa · 05/14/24

Try this:

=IF([Buyer Email]@row = "CC@gmail", "NO", IF([Buyer Email]@row = "CW@gmail", "NO", IF([GSP Status]@row = "Cancel", "NO", IF([MSI Proposed Settlement ($USD)]@row >= [Buyer Supervisor Limit]@row, "YES", IF([MSI Proposed Settlement ($USD)]@row = "", "TBD")))))

bisaacs · 05/14/24

Hey @HZAR,

I don't quite understand your 2nd condition request, but in general to require something to meet multiple conditions, uou would use the AND operator in the IF statement:

=IF(AND(logic requirement 1, logic requirement 2), true, false)

Hope this helps!

jcaguioa · 05/14/24

Try this:

=IF([Buyer Email]@row = "CC@gmail", "NO", IF([Buyer Email]@row = "CW@gmail", "NO", IF([GSP Status]@row = "Cancel", "NO", IF([MSI Proposed Settlement ($USD)]@row >= [Buyer Supervisor Limit]@row, "YES", IF([MSI Proposed Settlement ($USD)]@row = "", "TBD")))))

HZAR · 05/15/24

Hi @jcaguioa

Thanks for the input. It works so far for the testing file. Will map the formula to our original file. Thanks so much for your advise.

jcaguioa · 05/15/24

You're welcome! Let me know if there's something that needs to be modified and I'll be glad to help out!

IF Formula

Best Answer

Answers

Help Article Resources

Categories