Extracted Data Version
Overview
Grammar | MOD(number, divisor) | Returns the remainder after the number is divided by the divisor. The result has the same sign as the divisor. |
Parameter 1 | number | Number to be divided (dividend). |
Parameter 2 | divisor | Number that divides another number (divisor). If the divisor equals 0, the remainder is returned as infinite; if the dividend equals 0, the remainder is returned as 0. |
Notes
The function supports two numerical parameters.
Example
| Formula | Result | Notes |
|---|---|---|
| MOD(3,2) | 1 | |
| MOD(-3,2) | 1 | |
| MOD(3,-2) | -1 | |
| MOD(-3,-2) | -1 |
Direct Connect Version
Overview
| Grammar | MOD(number, divisor) | Returns the remainder after the number is divided by the divisor. The result has the same sign as the dividend. |
|---|---|---|
| Parameter 1 | number | Number to be divided (dividend). |
| Parameter 2 | divisor | Number that divides another number (divisor). If the divisor equals 0, the remainder is returned as infinite; if the dividend equals 0, the remainder is returned as 0. |
Notes
The function supports two numerical parameters.
Example
| Formula | Result | Notes |
|---|---|---|
| MOD(3,2) | 1 | |
| MOD(-3,2) | -1 | |
| MOD(3,-2) | 1 | |
| MOD(-3,-2) | -1 |
