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