150 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.
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
Data type returned
number
Mod number Div number;divisor( ) divisor•()–=
Commentaires sur ces manuels