Home > Reference > Functions reference > Number functions > Mod

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.

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