IF/AND/OR Functions

Megan.Francies

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.

Paul Newcome

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

Paul Newcome

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

Megan.Francies

Thanks Paul that worked! Appreciate your help!

Paul Newcome

Happy to help. 👍️