IF Formula

HZAR

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

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

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

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

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

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