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 | Type | Description |
|---|---|---|
| Number | Number | The number for which the remainder should be calculated. |
| Divisor | Number | The number by which the Number should be divided |
Return
| Type | Description |
|---|---|
| Number | 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 |