Loading…
Loading…
AND, OR and XOR combine several tests into one TRUE or FALSE. AND is TRUE only when every test is TRUE. OR is TRUE when at least one test is TRUE. XOR is TRUE when an odd number of tests are TRUE (with two tests: exactly one). They are often used inside IF.
Syntax
AND(logical1, [logical2], …) · OR(…) · XOR(…)
Example: =AND(B2>=50,C2>=75) is TRUE only if the score is at least 50 and attendance at least 75.
Common mistakes
Read the lesson, then try it yourself in a live spreadsheet.