Filemaker TH325Z/A Datový list stáhnout pdf (Strana 150)

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•()–=

1 2 ... 145 146 147 148 149 150 151 152 153 154 155 ... 237 238

Žádné komentáře

Filemaker TH325Z/A Datový list Strana 150