MODULUS (%) : calculate a division remainder (modulo)

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

value1 % value2

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.

Check whether a number is even or odd

The remainder of a division by 2 is always 0 for an even number, and 1 for an odd number.

$Number % 2

Result: 0 for 600, 2, or 4 (even numbers); 1 for 3 or 5 (odd numbers).

Display a label instead of 0/1: combine with IF() to get a readable text directly. Note the double == sign to test equality in a formula.

IF($Number % 2 == 0, "Even", "Odd")

Go further

DIVIDE

The division operator, whose remainder MODULUS returns.

Read more →

Or continue with

Formula glossary

All available operators and functions, sorted by category.