OR: accept any one of several conditions
OR fits a rule where one qualifying condition is enough. It is useful for warnings or flags, but a loose condition can make almost every row pass.
Either condition is enough. A ticket that satisfies both is still one ticket, so the Boolean result is TRUE rather than a count of matching rules. The strict > comparison means a three-day-old Normal ticket remains in the queue under this policy.
| Formula | Expected result / interpretation |
|---|---|
| =OR(A2=”High”,B2>3) | TRUE; fill down for TRUE, FALSE |
| =IF(OR(A2=”High”,B2>3),”Escalate”,”Queue”) | Escalate; fill down for Escalate, Queue |
| Row | A: Urgency | B: Age |
|---|---|---|
| 2 | High | 1 |
| 3 | Normal | 5 |
| 4 | Normal | 2 |
Enter urgency in A2:A4 and age in whole days in B2:B4. A ticket is flagged if marked High or older than three days.
Flag a ticket when either escalation rule applies
Formula syntax
=OR(logical1, [logical2], ...)
What goes into it
logical1
First condition or logical value.
logical2
Optional additional conditions.
A quick example first
=OR(FALSE,TRUE)
Returns TRUE.
=IF(OR(C2="Open",C2="Pending"),"Active","Closed")
Returns Active when either status condition matches.
Before you copy this into a real sheet
Check whether the rule should instead be >=3, and document that boundary. Use a controlled list for urgency labels and numeric validation for age. OR is inclusive: both conditions may be true. If exactly one condition must hold, that is a different rule. OR applied to a whole range collapses the tests into a single result; it does not produce a per-record spill in the way a FILTER include array requires. Keep row-level decisions visible when reviewing escalations.
Useful habits
- Use OR when at least one condition can satisfy the rule.
- Group OR conditions carefully when combined with AND.
- Test each status/criterion separately when unexpected rows match.
Where people get caught out
- Using OR when all conditions are required.
- Mixing AND and OR without making the intended grouping clear.
Other functions worth a look
A detail worth remembering
Before embedding OR inside IF, test a row where neither condition is true and a row where both are true. Those cases reveal loose rules.
Reference and examples
The examples above use small, invented datasets and English-language formula names. Check your Excel version and argument separator against the official Excel function reference if a formula behaves differently on your computer.