MOD
Returns the remainder of given number after it was divided by specified divisor. The result has the same sign as divisor.
Syntax
=MOD(Number, Divisor)
Arguments
| Name | Description |
|---|---|
| Number | The number for which the remainder should be calculated. |
| Divisor | The number by which the Number should be divided |
Return
The remainder of applied division. Note: it always has the same sign as divisor.
Examples
| Formula | Result | Comment |
|---|---|---|
| 1 | Remainder of 3/2 |
| 1 | Same sign as divisor |
| -1 | Same sign as divisor |