Page
|
|
|
Next Page |
|
| Contents > Functions reference (alphabetical list) > Number functions > Mod function |
|
|
| Mod function |
| Format |
Mod(number;divisor) |
| Parameters |
| number - any numeric expression or field containing a numeric expression |
| divisor - numeric expression or field containing a numeric expression |
| Data type returned |
| number |
| Description |
| Returns the remainder after number is divided by divisor. The result has the same sign as divisor. |
| Use the Mod function to test whether a number is even or odd by specifying a divisor of 2 (if the result is zero the number is even, otherwise it's odd). |
| Examples |
| Mod(13;4) returns 1. |
| Mod(7;5) returns 2. |
| Mod(7;-5) returns -3. |
| Mod(-7;5) returns 3. |
| Mod(-7;-5) returns -2. |
| Mod(Participants;TeamSize) returns 4 if Participants contains 40 and TeamSize contains 9. |
| If(Mod(Get(RecordNumber);2) = 0;"even";"odd") labels a record even or odd using the Get(RecordNumber) function. |
| Related topics |
|
Functions reference (category list) |
|
Functions reference (alphabetical list) |
|
About formulas |
|
About functions |
|
Defining calculation fields |
|
Using operators in formulas |
|
|
| Contents > Functions reference (alphabetical list) > Number functions > Mod function |
|
|
Next Page |
|