OR
Returns TRUE if at least one test passes.
How it’s written
OR(test1, test2)Example
| A | B | |
|---|---|---|
| 1 | Name | Score |
| 2 | Amara | 72 |
| 3 | Ben | 90 |
| 4 | Chloe | 65 |
| 5 | Dev | 90 |
| 6 | Elena | 83 |
=OR(B2>=80,B4>=80)Result: FALSE
Neither Amara nor Chloe scored 80.
Try it yourself
Open a live sheet with this example, and type the formula yourself. It takes a moment to load.
Worth knowing
OR can sit inside AND, so you can write detailed rules.
Practice it properly
Rules with several parts gives you real tasks, with your formulas tested on data you haven’t seen.