Edit

MOD

  • Article

Returns the remainder after a number is divided by a divisor. The result always has the same sign as the divisor.

Syntax

MOD(<number>, <divisor>)

Parameters

Term Definition
number The number for which you want to find the remainder after the division is performed.
divisor The number by which you want to divide.

Return value

A whole number.

Remarks

  • If the divisor is 0 (zero), MOD returns an error. You cannot divide by 0.

  • The MOD function can be expressed in terms of the INT function: MOD(n, d) = n - d*INT(n/d)

Example 1

The following formula returns 1, the remainder of 3 divided by 2.

= MOD(3,2)

Example 2

The following formula returns -1, the remainder of 3 divided by 2. Note that the sign is always the same as the sign of the divisor.

= MOD(-3,-2)

Related content

Math and Trig functions
ROUND function
ROUNDUP function
ROUNDDOWN function
MROUND function
INT function