Logical Functions
Intermediate
OR Function
Use OR function to test if any condition is true.
Task:
The company offers a bonus to employees who either have sales greater than $10,000 OR have been with the company for more than 5 years. Determine which employees get a bonus in column D.
Learning Objectives:
- Learn the OR function
- Understand alternative conditions
- Practice flexible logical operations
Hints
Solve without hints for +5 XP
The data in this exercise
This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Employee | Sales | Years | Bonus |
| 2 | John | 12000 | 3 | |
| 3 | Mary | 8000 | 7 | |
| 4 | Tom | 15000 | 2 | |
| 5 | Sarah | 7000 | 4 | |
| 6 | Mike | 9000 | 6 |
What this exercise teaches (contains the answer)
The OR function is used when at least one of several conditions needs to be met for a certain outcome.