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.

MOD(numerator,divisor)

  • MOD(11,2)

    Returns the value 1, which is the remainder of 11/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!

Related Topics