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!
Best Answer
-
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")))
Answers
-
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")))
-
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")))
-
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")))
-
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
-
Thank you so much all!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!