MOD Function

The MOD function is one of the math and trigonometry functions. It is used to return the remainder after the division of a number by the specified divisor.

Syntax

MOD(number, divisor)

The MOD function has the following argument:

Argument	Description
number	A number you wish to divide and find the remainder.
divisor	A number you wish to divide by.

Notes

If divisor is 0, the function returns the #DIV/0! error.

How to apply the MOD function.

Examples

The figure below displays the result returned by the MOD function.