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:

ArgumentDescription
numberA number you wish to divide and find the remainder.
divisorA 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.

MOD Function

Article with the tag:
Browse all tags