MOD
Computes the modulus (remainder) of the first input divided by the second input.
Syntax
MOD(N, M)
Arguments
N
Type: numeric
A numeric value representing the dividend.
M
Type: numeric
A numeric value representing the divisor.
Returns
Type: same as input
The remainder of N divided by M.
Examples
| N | M | Output |
|---|---|---|
| 1 | 1 | 0 |
| 1 | 0 | null |
| -1 | 1 | 0 |
| 0 | 0 | null |
| 3.3 | 1.1 | 1.0999999999999996 |
| 2.5 | 2.5 | 0.0 |
| 3.03 | 1.01 | 1.0099999999999998 |
| 0 | 2 | 0 |
| 9 | 2 | 1 |