IF Formula

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

Find more posts tagged with

Accepted answers

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")))))

All comments

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:

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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.