Logical Functions
Intermediate

OR on one column: either of two values

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

Task:

Overtime is paid at the weekend rate on Saturdays and Sundays. In C2:C7 show Weekend for those days and Weekday for the rest.

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.

    Core
    Intermediate
  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.

7 rows × 3 columns6 cells you fill in
ABC
1DateDayRate
23 MarFriday
34 MarSaturday
45 MarSunday
56 MarMonday
610 MarFriday
711 MarSaturday
What this exercise teachesMay contain the answer

The most common OR mistake is OR(B2="Saturday","Sunday"): the second argument is just the word Sunday, not a test of B2, and the formula falls over. Every condition in OR is a full comparison, even when they all look at the same cell.