MOD to pick every n-th item
A remainder of zero marks every fifth, tenth or hundredth row.
Task:
Quality control samples every fifth order. In B2:B9 show Sample for orders whose number divides exactly by 5, and Skip for the rest.
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 | |
|---|---|---|
| 1 | Order no. | QC |
| 2 | 1003 | |
| 3 | 1004 | |
| 4 | 1005 | |
| 5 | 1006 | |
| 6 | 1009 | |
| 7 | 1010 | |
| 8 | 1011 | |
| 9 | 1015 |
What this exercise teachesMay contain the answer
Sampling by order number rather than by row position means the choice survives sorting and filtering: order 1010 is always sampled, wherever it sits. MOD = 0 is the standard test for "is a multiple of".