Excel OR Function (Any Condition TRUE) – Examples & Practice
Practice the Excel OR function online with an interactive grid, instant feedback, and clear formula help.
Instruction
Check whether A3 is at least 85 or B3 is at least 90; return TRUE if either condition is met.
Formula Syntax
=OR(logical1, [logical2], ...)
- logical1: First condition that evaluates to TRUE or FALSE.
- [logical2]: Optional additional conditions.
- ...: Up to 255 tests.
What it does
OR returns TRUE if any supplied condition is TRUE. If every condition is FALSE, OR returns FALSE. It is commonly nested inside IF to branch on flexible rules.
Excel OR Function Examples
Basic OR
=OR(A1>10, B1<5)
TRUE if either condition holds.
OR with text
=OR(A1="VIP", B1="Priority")
TRUE if either label matches.
OR inside IF
=IF(OR(A1<0, B1>100), "Review", "OK")
Returns Review when either edge case triggers.
logical-checks.xlsx
| A | B | C | |
|---|---|---|---|
| 1 | Score | Attendance % | Approved |
| 2 | 92 | 96 | Yes |
| 3 | 78 | 88 | No |
| 4 | 85 | 91 | Yes |
| 5 | 66 | 84 | No |
| 6 | 90 | 93 | Yes |
| 7 | Output |
Input Formula
Need Help?
Tips
- Write each test so it clearly evaluates to TRUE/FALSE.
- Prefer readable nested IF over mega-OR when rules grow.
- Pair with AND when you need both strict and flexible parts.
OR Function Use Cases
- Approve when any qualifying flag is set
- Detect out-of-range values on multiple checks
- Combine with IF for readable branching
- Model flexible eligibility rules
- Highlight exceptions in dashboards
Common mistakes - OR function not working
- Using OR when business logic requires AND
- Forgetting parentheses when nesting with IF
- Mixing text comparisons without quotes
- Expecting exclusive-or behavior (that is XOR)
- Using OR on whole ranges without array awareness
FAQ
How is OR different from AND?
OR returns TRUE if any argument is TRUE. AND requires every argument to be TRUE.
Can OR handle more than two tests?
Yes. You can chain many logical tests in one OR function.
Can I nest OR inside IF?
Yes. This is a common pattern for flexible business rules.
Does OR work with arrays?
In dynamic Excel, array behavior can spill; in legacy formulas, use careful array entry or helper columns.
What if every test is FALSE?
OR returns FALSE when no condition is TRUE.
Comparison
| Function | TRUE when… |
|---|---|
| OR | Any test is TRUE |
| AND | All tests are TRUE |
| XOR | Exactly one test is TRUE |
Example
=OR(A1>10, B1<20)
=AND(A1>10, B1<20) requires both.
Advanced examples
OR + AND together
Nest OR inside AND (or the reverse) to model realistic policies:
=AND(A1>0, OR(B1="Yes", C1="Yes"))