Trying to combine IF, OR, & AND
As the title states, I am trying to create a helper column that is checked or unchecked based on a few conditions. I want to check the helper column box if statements 1 and 2 are both true or if statements 1 and 2 are both false. I had written:
IF(OR(AND(statement 1@row = 1, statement 2@row = 1), AND(statement 1@row = 0, statement 2@row = 0)), 1, 0)
Not certain if this is the right order or even the way to go. Please let me know what you all think.
Help Article Resources
Check out the Formula Handbook template!