1. Calculation functions
  2. All functions
  3. Numeric functions
  4. MOD

The MOD function returns the remainder when one number is divided by another, or modulo.

Syntax

MOD(Dividend, Divisor)

Arguments

ArgumentData typeDescription
DividendNumberThe number to divide.
DivisorNumber

The number to divide by.

If this is 0, the MOD function returns a value of 0.

The MOD function returns a numeric value.

Excel equivalent

MOD

Examples

FormulaResult
MOD(10, 3)1
MOD(26.6, 7.1)5.3
MOD(-50,7)6
MOD(271.56, -8.8)-1.24
MOD(5, 0)0
MOD(0, 5)0



Disclaimer

We may update our documentation occasionally, but will only do so in a way that does not negatively affect the features and functionality of the Anaplan service.