Description
Returns the remainder after dividing a number by a specified divisor.
Syntax
MOD ( number, divisor )
Parameter | Description |
---|---|
number | Any number. |
divisor | Any nonzero number. If divisor is 0, #DIV/0! is returned. |
Examples
This function returns 1:
MOD(-23, 3)
This function returns -2:
MOD(-23, -3)
See also