Skip to main content

MOD

The MOD function returns the remainder after a number is divided by a divisor.

Syntax​

=MOD(number, divisor)

Parameters​

  • number: The number for which you want to find the remainder
  • divisor: The number by which you want to divide

Examples​

=MOD(7, 3) // Returns 1
=MOD(15, 4) // Returns 3
=MOD(-5, 2) // Returns -1