# OR function in Excel

> OR returns TRUE when at least one of its conditions is TRUE.

Source: https://spreadsheetpractice.com/functions/or · Updated October 28, 2026 · Formulas and results on this page were run by the Spreadsheet Practice formula engine on November 20, 2026

## Quick answer

- **What it does:** OR returns TRUE when at least one of its conditions is TRUE.
- **Syntax:** `=OR(logical1, [logical2], ...)`
- **Most common use:** `=OR(B2>=100,C2="Yes")` returns TRUE (A member, so TRUE even though the order is under $100)
- **Available in:** Every current version
- **Category:** [Logical functions](https://spreadsheetpractice.com/functions/category/logic)
- **Returns:** TRUE if any argument is TRUE, FALSE only when every argument is FALSE.
- **Google Sheets:** Works the same way in Google Sheets.

## What it does

OR returns TRUE when at least one of its conditions is TRUE. Use it inside IF when any one of several reasons should lead to the same result: free shipping for large orders or members, or a flag for orders that are late or damaged.

## Syntax

`=OR(logical1, [logical2], ...)`

| Argument | Required? | What it is |
|---|---|---|
| `logical1` | Required | The first condition, such as B2>=100. |
| `logical2` | Optional | More conditions, up to 255 in total. |

## Examples

Each result was calculated by running the formula on the sample sheet.

| Cell | Formula | Result | What it shows |
|---|---|---|---|
| D2 | `=OR(B2>=100,C2="Yes")` | TRUE | A member, so TRUE even though the order is under $100 |
| D3 | `=IF(OR(B3>=100,C3="Yes"),0,7.99)` | $0.00 | Inside IF: shipping is free when either condition holds |
| D4 | `=OR(B4>=100,C4="Yes")` | FALSE | Neither condition is met, so FALSE |

### The sample sheet

Every formula above runs on this data:

|  | A | B | C | D |
|---|---|---|---|---|
| 1 | Order | Total | Member | Result |
| 2 | W-501 | $72 | Yes | TRUE |
| 3 | W-502 | $140 | No | $0.00 |
| 4 | W-503 | $35 | No | FALSE |

## Common mistakes

| What you see | Why, and how to fix it |
|---|---|
| Expecting OR to need every condition | OR is satisfied by a single TRUE. If all the conditions must hold, use AND. |
| #VALUE! from a shortcut | =OR(C2="East","West") returns #VALUE! because "West" on its own isn't a test. Repeat the cell: =OR(C2="East",C2="West"). |

## Tips

- =OR(C2={"East","West","North"}) tests one cell against several values without repeating C2.

## Related functions

- [AND](https://spreadsheetpractice.com/functions/and): AND returns TRUE only when every condition you give it is TRUE.
- [XOR](https://spreadsheetpractice.com/functions/xor): XOR returns TRUE when an odd number of its conditions are TRUE.
- [NOT](https://spreadsheetpractice.com/functions/not): NOT flips a logical value: TRUE becomes FALSE and FALSE becomes TRUE.
- [IF](https://spreadsheetpractice.com/functions/if): IF checks a condition and returns one value when it is true and another when it is false.

## Questions

### How do I use IF with OR?

Make OR the first argument of IF: =IF(OR(B2>=100,C2="Yes"),"Free","$7.99"). One TRUE condition is enough.

### Can I combine AND and OR?

Yes. =IF(AND(B2>100,OR(C2="East",C2="West")),"Bonus","") requires a total over 100 and either region.

## Practice

A graded OR exercise ("Free shipping rule") is on [the OR page](https://spreadsheetpractice.com/functions/or). It is checked instantly, then re-checked on changed data.

Lessons that use OR:

- [Lesson 6: AND, OR & IFS](https://spreadsheetpractice.com/learn/and-or-ifs)
- [Lesson 37: Median, quartiles & outliers](https://spreadsheetpractice.com/learn/median-quartiles-outliers) (Pro)

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
