Syntax
=OR(logical1, [logical2, ...])
logical1- The first condition.
logical2, ...- Optional. More conditions.
OR function in Google Sheets
OR returns TRUE when at least one of its conditions is TRUE. Use it when any one of several situations should trigger the same result.
Practice OR
Task 1 of 1
Customers get a refund if the order was more than 5 days late OR arrived damaged. Return TRUE/FALSE in D2.
Tip: while typing a formula, click a cell or drag across cells to insert references. Press Enter to check, and Tab to accept a function suggestion.
OR examples
Each example below runs against this sample sheet. The results are calculated by the same engine as the practice grid.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Student | Class | Score | Passed |
| 2 | Priya | A | 92 | TRUE |
| 3 | Leo | B | 67 | FALSE |
| 4 | Chloe | A | 48 | FALSE |
| 5 | Mateo | B | 81 | TRUE |
| 6 | Ines | C | FALSE | |
| 7 | Kai | C | 75 | TRUE |
| Formula | Result | What it shows |
|---|---|---|
=OR(C4>=70, B4="A") | TRUE | Chloe failed but is in class A. |
=OR(C3>90, C4>90) | FALSE | Neither score is above 90. |
=OR(D2:D7) | TRUE | Did anyone pass? |
Tips and common mistakes
- Inside COUNTIFS and SUMIFS every condition is AND. To get OR there, add separate COUNTIF/SUMIF results together.
Related functions
Learning step by step? OR is covered in Lesson 7: AND, OR, NOT & XOR of the free course.