You are here: Help Topics > Accounting and Assurance > Calculations, Functions and Linkages > MOD function
-- Reference --
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.
Note: If the divisor is 0, then you will receive the warning #DIV/0!