Excel MOD Function
The Excel MOD function returns the remainder of two numbers after division. For example, MOD(10,3) = 1. The result of MOD carries the same sign as the divisor.
- number - The number to be divided.
- divisor - The number to divide with.
Use the MOD function to get a reminder after division. For example, MOD(3,2) returns 1, because 2 goes into 3 once, with a remainder of 1.
Here are a few examples of the MOD function with hardcoded values:
With very large numbers, you may see the MOD function return a #NUM error. In that case, you can try an alternative version based on the INT function:
- MOD is often seen in formulas that deal with "every nth" value
- MOD is useful for extracting the time from a date
- MOD always returns a result in the same sign as the divisor.
- MOD will return a #DIV/0! error if the divisor is zero