AND / OR
How to use AND and OR in Excel to check multiple conditions
AND returns TRUE if all conditions are met; OR returns TRUE if at least one is met.
Syntax
=AND(logical1, [logical2], ...)
- logical1, ... — Up to 255 conditions that each return TRUE/FALSE.
Example
Formula:
=AND(B2>=2,C2>=80)→ result: TRUE
AND
Returns TRUE only when every condition is true. For example, a candidate must have more than 2 years of experience AND a score above 80.
OR
Returns TRUE if at least one condition is true. =OR(B2="Tashkent",B2="Samarkand").
Combining with IF
In practice, AND/OR are most often used inside IF: =IF(AND(B2>=2,C2>=80),"Accepted","Rejected").
Put it into practice
Do interactive exercises on this topic in the Excel simulator.
Start exerciseFrequently asked questions
XOR returns TRUE when an odd number of conditions are true — handy for checking that exactly one of two conditions is met.
NOT reverses the result: =NOT(B2>100) returns TRUE if B2 is not greater than 100.