IF/AND/OR Functions
Good Morning,
I am looking to get some help setting up a formula based on a few conditions. The first condition is IF column BAG COUNT has a value = 0 AND column Response Form Received = Y then if the statement is true it should input YES into All documents if False NO. The second condition is if column BAG COUNT has a value >0 AND column Response Form Received = Y AND column Destruction Form Received = Y then if the statement is true it should input YES into column All Documents, if false NO should be inputted.
Basically I have 2 different conditions based on column bag destroyed and depending on if there is a value larger than zero will determine if both forms are required or only 1.
What would be the easiest formula to achieve this? I have tried multiple reiterations of IF/AND statements but the whole string always puts out an error.
Best Answer
-
Try something like this:
=IF(OR(AND([Bag Count]@row = 0, [Response Form Received]@row = "Y"), AND([Bag Count]@row> 0, [Response Form Received]@row = "Y", [Destruction Form]@row = "Y")), "YES", "NO")
Answers
-
Try something like this:
=IF(OR(AND([Bag Count]@row = 0, [Response Form Received]@row = "Y"), AND([Bag Count]@row> 0, [Response Form Received]@row = "Y", [Destruction Form]@row = "Y")), "YES", "NO")
-
Thanks Paul that worked! Appreciate your help!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 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!