Filemaker Upgrade to FileMaker Pro 8.5 Advanced TH334Z/A Manual Do Utilizador
Códigos do produto
TH334Z/A
150 FileMaker Functions Reference
Mod
Format
Mod(number;divisor)
Parameters
number - any numeric
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
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
•
(
)
–
=