Logical FunctionsIntermediate

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.

Hints

+5 XPno-hints bonus

Solve it on your own to keep the bonus. Each hint gets one step closer to the formula.

Variations of AND, OR, NOT

0/3

The same formula in the other shapes it takes at work.

  1. OR Function

    Use OR function to test if any condition is true.

    CoreIntermediate
  2. OR on one column: either of two values

    Weekend is Saturday or Sunday — two values for the same cell.

    Intermediate
  3. OR to flag any one of several problems

    A row needs a look if anything at all is wrong with it.

    Intermediate

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.

6 rows × 4 columns5 cells you fill in
ABCD
1EmployeeSalesYearsBonus
2John120003
3Mary80007
4Tom150002
5Sarah70004
6Mike90006
What this exercise teachesMay contain the answer

The OR function is used when at least one of several conditions needs to be met for a certain outcome.