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 update Anapedia regularly to provide the most up-to-date instructions.