MOD Function
Find remainders using the MOD function.
Task:
You are managing inventory and need to determine how many items can be fully packed into boxes and what remains. Calculate the remainder when dividing by 3 in column C to find out how many items are left over after packing items into boxes of 3.
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 | Number | Divide by 3 (for info) | Remainder |
| 2 | 10 | 3.33 | |
| 3 | 15 | 5 | |
| 4 | 22 | 7.33 | |
| 5 | 18 | 6 |
Functions used here
What this exercise teachesMay contain the answer
The MOD function is useful for finding remainders, which can be applied in scenarios like packaging, scheduling, or pattern detection.