Mod
Purpose 
Returns the remainder after number is divided by divisor.
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
Originated in 
FileMaker Pro 6.0 or earlier
Description 
Use the Mod function to test whether a number is even or odd by specifying a divisor of 2. If the result is zero, then the number is even; otherwise, it’s odd. The result has the same sign as divisor.
Equation
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