Microsoft® Excel® 2010 Formulas & Functions Inside Out

MOD()

Syntax. MOD(number,divisor)

Definition. This function returns the remainder of a division operation. The result has the same sign as the divisor.

Arguments

• number (required) The number for which you want to find the remainder

• divisor (required) The number by which you want to divide number

Background. For certain calculations, you need the remainder of a division operation. This is also called modulo (mod). For this type of calculation, you can use the MOD() function.

If the divisor is 0, the MOD() function returns the #DIV/0! error.

The MOD() function can be expressed in terms of the INT() function:

=numerator-divisor • INT(numerator/divisor)

This formula is used for the modulo method in software systems. There are two types of modulo calculations, ...