How AND/OR criteria work?
AND operator
The AND operator is used in cases where we have two or more conditions and we need all of them to be true.
Condition 1 |
Condition 2 |
Result |
Pass |
Failed |
Failed |
Pass |
Pass |
Pass |
Failed |
Pass |
Failed |
Failed |
Failed |
Failed |
OR operator
The OR operator is also used in cases where we have two or more conditions and we need only one of them to be true. The remaining conditions can be true or false, but at least one must be true.
Condition 1 |
Condition 2 |
Result |
Pass |
Failed |
Pass |
Pass |
Pass |
Pass |
Failed |
Pass |
Pass |
Failed |
Failed |
Failed |
Note
You can't combine multiple AND and OR together, it can make you confused and break your logic.