Filemaker Pro 8.5 Advanced Maintenance TG761Z/A User Manual

Mod(number;divisor)

number - any numeric 

 or 

divisor - numeric expression or field containing a numeric expression

number

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).

Mod(13;4) returns 

.

Mod(7;5) returns 

.

Mod(7;-5) returns 

.

Mod(-7;5) returns 

.

Mod(-7;-5) returns 

.

Mod(Participants;TeamSize) returns 

 if Participants contains 

 and TeamSize 

contains 

.

If(Mod(Get(RecordNumber);2) = 0;“even”;“odd”) labels a record even or odd 

using the Get(RecordNumber) function.

Random

None

number

Mod

number

Div number;divisor

(

) divisor

•

(

)

–

=