MOD
Returns the remainder after dividing.
How it’s written
MOD(number, divisor)Example
| A | |
|---|---|
| 1 | Items |
| 2 | 17 |
=MOD(A2,5)Result: 2
17 divided by 5 leaves a remainder of 2.
Try it yourself
Open a live sheet with this example, and type the formula yourself. It takes a moment to load.
Worth knowing
MOD(A2,2)=0 is the classic test for an even number.
Practice it properly
Rounding properly gives you real tasks, with your formulas tested on data you haven’t seen.