Functions Reference

144 FileMaker Functions Reference
Mod
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.
Random
Format
Random
Parameter
None
Μοδ νυμβερ Διϖ νυμβερ;διϖισορ()διϖισορ•()–=