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

MOD(Dividend, Divisor)

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.

MOD

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