Functions
MOD
Remainder after division
Try it
When to use it
When should I use MOD?
Use MOD to get the remainder after division, which is handy for spotting even/odd values or repeating cycles.
How do I test whether a number is even with MOD?
Take MOD of the number by 2; a result of 0 means even and 1 means odd.
Use cases
Check whether a number is even
Find position within a repeating cycle
Used in
operations · engineering · science
Syntax
MOD(number, divisor)Examples
=MOD(10,4) // => 2
=MOD(21,14) // => 7