MOD
Formulas / MODCalculates the remainder when two numbers are divided
=MOD(number, divisor)
- number - the number being divided
- divisor - the number doing the dividing
Examples
=MOD(7,3) // returns 1In this example, the MOD function returns 1.
=MOD(7,-3) // returns -2In this example, the MOD function returns -2 because of how INT rounds down negative numbers.
=MOD(12,3) // returns 0MOD returns 0 in this example.
=MOD(12,5) // returns 2MOD returns 2 in this example.
=MOD (100,33) // returns 1This is another example of how to use MOD. Here, MOD returns 1.
=MOD(6.25,1) // returns 0.25In this example, MOD returns 0.25, a decimal.
=MOD(-3,2) // returns 1=MOD(3,-2) // returns -1=MOD(-3,-2) // returns -1
Summary
The MOD function is used to calculate the remainder of a division operation between two numbers. The result of the operation will have the same sign as the divisor.
- The MOD function can be used to return the remainder of a division, to find "every nth" value in a formula, or to get the time from a date.
- The sign of the number that MOD returns is the same as the divisor.
- If the divisor equals zero, MOD will throw a #DIV/0! error.
- Use the QUOTIENT function if you want to discard the remainder and only keep the integer.
Frequently Asked Questions
What does the MOD function do?
The MOD function returns the remainder from dividing two numbers.
What arguments does the MOD function take?
The MOD function takes two arguments: number and divisor.
Are both arguments required for the MOD function?
Yes, both arguments are required for the MOD function.
What does the MOD function do with its arguments?
The number argument is divided by the divisor argument.
What error does MOD throw when the divisor equals 0?
MOD throws a #DIV/0! error if the divisor equals 0.
Can MOD be expressed using the INT function?
Yes, MOD may be expressed using the INT function: MOD(n, d) = n - d*INT(n/d).
