← Back to level 1
Level 1Next
OR
A easy logic formula for situations where any one of several conditions can make the result true.
Syntax
=OR(...)Step-by-step explanation
- 1List the logical tests that OR should evaluate before you finish the formula.
- 2Use OR when you need all conditions to be true, any condition to be true, or the result to be reversed.
- 3Check the final TRUE or FALSE output against a simple test case before copying it down.
Common mistakes
Requiring all conditions instead of any condition
Writing conditions that are too broad
Forgetting to group logical tests clearly
Example table
A quick scenario to connect the syntax to the result.
| 12 | 18 |
| 8 | 42 |
Formula
=OR(A1:B2)
Result
42
Worked example
- 1Read the sample data first so you know what the formula needs to solve.
- 2Enter =OR(A1:B2) in the result cell and press Enter.
- 3Check that the output matches 42.
Practice area
Use OR when one of several rules should be enough to trigger the result.
Match against the syntax block above.