The MODULUS (%) operator returns the remainder of an integer division between two numbers. It is useful to know what is left over after a division, or to check whether a number is divisible by another. The result is always a whole number.
Syntax
Dividend % Divisor
Examples
Get the remainder of a division
10 divided by 3 gives a quotient of 3 with a remainder of 1.
10 % 3
Result: 1 (the remainder of the division).
An exactly divisible number
15 % 5 returns 0, because 15 is divisible by 5 with no remainder. This property is often used to check whether a number is even, whether a particular day falls in a cycle, or to distribute items cyclically.
Go further
DIVIDE
The division operator, whose remainder MODULUS returns.
Or continue with
Formula glossary
All available operators and functions, sorted by category.