What it does
OR takes as many conditions as you like: =OR(C2>10000,B2="New"). If any of them is TRUE, the result is TRUE; only when all are FALSE does it return FALSE. The result usually goes into the test of IF.
It is also used to compare one cell with several values: =OR(B2="Returned",B2="Cancelled"). The formula gets long as the values pile up; at that point it is easier to list the values and test with ISNUMBER(MATCH(B2,$F$2:$F$6,0)).
If every condition must hold, use AND; to reverse a condition, use NOT. If you want exactly one of the conditions to be true, there is XOR.
Syntax
=OR(logical1, [logical2], ...)=YADA(mantıksal1; [mantıksal2]; ...)Arguments in square brackets are optional. English Excel separates arguments with commas (,) and uses a dot for decimals; Turkish Excel uses semicolons (;) and a decimal comma. Excel shows function names in its own language when it opens the file.
Arguments
| Argument | Required | Description |
|---|---|---|
logical1 | Required | The first condition, one that results in TRUE or FALSE, e.g. C2>10000. |
logical2 | Optional | The next condition to test; up to 255 conditions are allowed. |
Examples
1Does an overtime date fall on a weekend?
With return_type 2, WEEKDAY gives 6 for Saturday and 7 for Sunday. OR returns TRUE if either of the two conditions holds.
=OR(WEEKDAY(A2,2)=6,WEEKDAY(A2,2)=7)| A | B | C | |
|---|---|---|---|
| 1 | Overtime Date | Hours | Weekend? |
| 2 | 6-Nov-2026 | 3 | FALSE |
| 3 | 7-Nov-2026 | 5 | TRUE |
| 4 | 8-Nov-2026 | 4 | TRUE |
| 5 | 9-Nov-2026 | 2 | FALSE |
- C2 (filled down to C5)
=OR(WEEKDAY(A2,2)=6,WEEKDAY(A2,2)=7)
Saturday 7 November and Sunday 8 November show TRUE; Friday 6 November shows FALSE. You can use this column to total weekend overtime separately.
We recalculated this example in real Excel (Microsoft 365, 16.0) and compared the results: they match.
2Send orders for approval when either condition holds
An order goes for approval if the amount is over 10,000 or the customer is new; the rest are approved automatically. OR goes into the test of IF.
=IF(OR(C2>10000,B2="New"),"Send for approval","Auto-approve")| A | B | C | D | |
|---|---|---|---|---|
| 1 | Order | Customer Type | Amount | Approval |
| 2 | SO-801 | Existing | 4,200.00 | Auto-approve |
| 3 | SO-802 | New | 1,850.00 | Send for approval |
| 4 | SO-803 | Existing | 12,750.00 | Send for approval |
| 5 | SO-804 | New | 15,400.00 | Send for approval |
| 6 | SO-805 | Existing | 9,990.00 | Auto-approve |
- D2 (filled down to D6)
=IF(OR(C2>10000,B2="New"),"Send for approval","Auto-approve")
SO-802 is a small order but comes from a new customer: Send for approval. SO-805 meets neither condition and gets Auto-approve. SO-804 meets both, and the result is the same: Send for approval.
We recalculated this example in real Excel (Microsoft 365, 16.0) and compared the results: they match.
Common errors and fixes
- #VALUE!
Cause: The test was written incompletely, like
OR(B2="Returned","Cancelled"); the second argument is plain text, not a comparison.Fix: Write each value as its own comparison:
OR(B2="Returned",B2="Cancelled").- Unexpected TRUE
Cause: An empty cell was compared with a number;
B2<100is true for an empty cell because it counts as 0.Fix: Test for empty cells as well:
AND(B2<>"",B2<100).
Good to know
- OR also reduces a whole range to one result. For an "or" test across many rows, add the conditions:
(B2:B9="Returned")+(B2:B9="Cancelled"). - There is a shorter weekend test as well:
=WEEKDAY(A2,2)>5.
In Nexell
Get Nexell to do it from a sentence
In the order list, write "Send for approval" next to orders over 10,000 or from new customers
Convert to tableBring your order list into the tool and type this. Nexell adds the conditional column with real Excel formulas and the preview shows which orders were flagged; in the downloaded file, the flag changes when the amount does.
Nexell uses AI to understand the request and builds the result with real Excel formulas; the formula may differ from the example on this page. You see a preview first and nothing changes until you press Apply; formulas stay live in the downloaded .xlsx file.
Free account · no card needed · 30 credits a month
Frequently asked questions
What is the difference between OR and AND?
AND returns TRUE only if every condition is true; for OR, one true condition is enough. If an order must be both over 10,000 and from a new customer, use AND; if either is enough, use OR.