You are here: Help Topics > Customization > Calculation > MOD Function

MOD Function

The MOD function calculates the remainder when one number, the numerator, is divided by another, the divisor.

Syntax

MOD(numerator,divisor)

Example 1

MOD(11,2)

Returns the value 1, which is the remainder of 11/2.

Example 2

MOD(-13,5)

Returns the value -3, which is the remainder of -13/5.

Notes

  • If the divisor is 0, then you will receive the warning #DIV/0!

Related Topics