MOD by 2: odd or even
The remainder after halving tells you which side of the street.
Task:
Couriers split each street by side: even house numbers on the left, odd on the right. In C2:C7 show Left or Right for each delivery.
Interactive Spreadsheet
Hints
+5 XPno-hints bonusSolve it on your own to keep the bonus. Each hint gets one step closer to the formula.
Variations of MOD
0/4The same formula in the other shapes it takes at work.
- MOD Function
Find remainders using the MOD function.
CoreIntermediate - MOD to pick every n-th item
A remainder of zero marks every fifth, tenth or hundredth row.
Intermediate - Minutes into hours and minutes
QUOTIENT gives the whole hours, MOD the minutes left over.
Intermediate - MOD by 2: odd or even
The remainder after halving tells you which side of the street.
Beginner
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 | |
|---|---|---|---|
| 1 | Street | No. | Side |
| 2 | Park Road | 14 | |
| 3 | Park Road | 27 | |
| 4 | Mill Street | 3 | |
| 5 | Mill Street | 108 | |
| 6 | Bank Lane | 41 | |
| 7 | Bank Lane | 50 |
What this exercise teachesMay contain the answer
MOD by 2 is the simplest parity test there is, and the same idea alternates row shading, splits a list into two teams or pairs up shifts. Any repeating pattern of length n is a MOD by n.