AND / OR / NOT — Excel guide
Combine conditions: AND needs every test true, OR needs at least one. They feed IFs, conditional formatting rules, and (as arithmetic) array formulas.
AND
TRUE only when ALL arguments are true.
- The between-check: AND(A1>=1, A1<=10). Excel has no 1<=A1<=10 chaining.
- AND evaluates every argument — it won't short-circuit past a division by zero.
OR
TRUE when AT LEAST ONE argument is true.
- There's no infix syntax — A1="x" OR A1="y" is an error; the tests go inside OR( ).
- XOR is the exactly-one variant (odd number of TRUEs, strictly).
NOT
Flip a logical value.
- In array math, * is AND and + is OR: SUMPRODUCT((A:A="East")*(B:B>100)) counts rows passing both.
- 'At least 2 of 3': add the conditions — (c1)+(c2)+(c3)>=2.