Description
Returns the remainder of a division, after the given Number is divided by the divisor.
Syntax
MOD(Number, Divisor)
Arguments
| Argument | Type | Dimensions | Description |
|---|---|---|---|
| Number (required) | Number | Any Dimensions | Number to divide. |
| Divisor (required) | Number | No Dimension or Dimensions of Number | Number to divide with. |
Returns
| Type | Dimensions |
|---|---|
| Number | Dimensions of argument Number |
Examples
| Formula | Result | Description |
|---|---|---|
MOD(19, 5) | 4 | 19 divided by 5 has a remainder of 4. |
MOD(2, 5) | 2 | 2 divided by 5 has a remainder of 2. |
See also
Excel: MOD
Related articles: QUOTIENT
More of a hands-on learner?
Talk to your Customer Success Manager about downloading the Functions and Modifiers in Pigment Application into your workspace. It includes examples of every formula and modifier in Pigment!
