Excel - MOD Function
Description
The MOD function returns the remainder after number is divided by divisor. The result has the same sign as divisor.
Syntax
MOD (number, divisor)
Arguments
| Argument | Description | Required/Optional |
|---|---|---|
| Number | The number for which you want to find the remainder. | Required |
| Divisor | The number by which you want to divide number. | Required |
Notes
The MOD function can be expressed in terms of the INT function −
MOD (n, d) = n - d*INT (n/d)
If divisor is 0, MOD returns the #DIV/0! error value
Applicability
Excel 2007, Excel 2010, Excel 2013, Excel 2016
Example
Advertisements