Definition. This function returns the remainder of a division operation. The result has the same sign as the divisor.
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
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, ...