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 Value
The remainder of applied division. Note: it always has the same sign as divisor.
Example
Function | Result | Comment |
---|---|---|
=MOD(3, 2) | 1 | Remainder of 3/2 |
=MOD(-3, 2) | 1 | Same sign as divisor |
=MOD(3, -2) | -1 | Same sign as divisor |