MOD function. Surplus.(Microsoft Excel)
If you perform division with the arithmetic operators, you will get a decimal fraction.
If you want to get the remainder of the division, use the MOD function instead of the arithmetic operator.
If you want to get the integer part instead of the remainder, use the QUOTIENT function.
The MOD function is used infrequently by itself, but it is effective when used in combination with other functions.
Contents
How it works
=MOD(number, divisor)
| Name | Omission | Explanation |
|---|---|---|
| number | Required argument. | The number for which you want to find the remainder. |
| divisor | Required argument. | The number by which you want to divide number. |
Demonstrate
Since this is a division, zero division is not possible and a #DIV/0 error is displayed.
Spill
Spill if either or both of the "number" and "divisor" arguments are cell ranges.
---