AND and OR Functions
Logical Functions: AND and OR
Managing Multiple Conditions in a Single Formula
Sometimes a single condition isn't enough. You might need to check if a student passed both Math and Science, or if a customer qualifies for a discount via either a coupon or a membership.
AND Function
Returns TRUE only if ALL conditions are met. If even one is false, the whole thing is false.
=AND(B2>=35, C2>=35)
Example: "Must pass Math AND Science."
OR Function
Returns TRUE if ANY single condition is met. It only returns false if everything is false.
=OR(D2="Yes", E2="Yes")
Example: "Has Coupon OR Membership."
Understanding the Logic
| If Test 1 is... | If Test 2 is... | AND Result | OR Result |
|---|---|---|---|
| TRUE | TRUE | TRUE | TRUE |
| TRUE | FALSE | FALSE | TRUE |
| FALSE | FALSE | FALSE | FALSE |
⚡ The Power Move: Nesting with IF
In the real world, you rarely use AND or OR by themselves. You put them inside an IF function to get a readable result:
=IF(AND(B2>=35, C2>=35), "Graduate", "Incomplete")
💡 Skill Eco Pro-Tip: Unlimited Conditions
You aren't limited to just two conditions! You can add up to 255 conditions inside an AND or OR function. For example: =AND(A1>0, B1>0, C1>0, D1>0) ensures every single cell in that row has a positive value.
🏋️ Test Yourself With Exercises
Take our quiz on AND and OR Functions to test your knowledge.
Exercise »