Can someone help me put together a complex logic formula?

I'm looking to put together a formula that outputs a status based on a few criteria.

This formula should output "Denied" by default.

If the [Price] is $500 or less and [ManagerApproval] = "Approved", output "Confirmed".

If the [Price] is more than $500 but less than $1000 and [ManagerApproval] = "Approved and [DirectorApproval] = "Approved", output "Confirmed".

If the [Price] is more than $1000 and [ManagerApproval], [DirectorApproval], and [ChiefOfficerApproval] all = "Approved", output "Confirmed"

I'm going to keep working on this myself, but if anyone has a decent implementation idea for this, please let me know.

Thank you so much!

Find more posts tagged with

Accepted answers

JamesB

@danielccascadecomp

This should work.

=IF(AND(Price@row < 500, ManagerApproval@row = "Approved"), "Confirmed", IF(AND(Price@row < 1000, ManagerApproval@row = "Approved", DirectorApproval@row = "Approved"), "Confirmed", IF(AND(Price@row > 1000, ManagerApproval@row = "Approved", DirectorApproval@row = "Approved", ChiefOfficerApproval@row = "Approved"), "Confirmed", "Unconfirmed")))

All comments

JamesB

@danielccascadecomp

This should work.

Leibel S

This should work:

=IF(Price@row <= 500, IF(ManagerApproval@row = "Approved", "Confirmed", "Denied"), IF(Price@row <= 1000, IF(AND(ManagerApproval@row = "Approved", DirectorApproval@row = "Approved"), "Confirmed", "Denied"), IF(AND(ManagerApproval@row = "Approved", DirectorApproval@row = "Approved", ChiefOfficerApproval@row = "Approved"), "Confirmed", "Denied")))

Eric_

You already wrote your formula with your detailed explanation 😀. You can nest IF statements and use the AND operator.

=IF(AND(Price@row <= 500, ManagerApproval@row = "Approved"), "Confirmed", IF(AND(Price@row < 1000, ManagerApproval@row = "Approved", DirectorApproval@row = "Approved"), "Confirmed", IF(AND(ManagerApproval@row = "Approved", DirectorApproval@row = "Approved", ChiefOfficerApproval@row = "Approved"), "Confirmed", "Denied")))

Linda Manduchova

Hello @danielccascadecomp -

Try out the following formula:

=IF(OR(AND(Price@row <= 500, ManagerApproval@row = "Approved"), AND(Price@row > 500, Price@row < 1000, ManagerApproval@row = "Approved", DirectorApproval@row = "Approved"), AND(Price@row >= 1000, ManagerApproval@row = "Approved", DirectorApproval@row = "Approved", ChiefOfficerApproval@row = "Approved")), "Confirmed", "Denied")

Cheers,

Linda

danielccascadecomp

Thank you so much all!

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.