Functions Reference

140 FileMaker Functions Reference
Description
Returns the next lowest integer value after dividing number by divisor. The Div
function is equivalent to Floor(number/divisor).
Examples
Div(2.5;2) returns 1.
Div(-2.5;2) returns -2.
Exp
Format
Exp(number)
Parameter
number - any numeric expression or field containing a numeric expression
Data type returned
number
Description
Returns the value of the constant e (the base of the natural logarithm, equal to 2.7182818)
raised to the power of number. The Exp function is the inverse of the Ln function.
Examples
Exp(1) returns 2.71828182....
Exp(Ln(2)) returns 2.
Exp(0) returns 1.
Factorial
Format
Factorial(number{;numberOfFactors})
Parameters
number - numeric expression
or field containing a positive integer.
numberOfFactors - any numeric expression or field containing a number that
represents how many factors to include in the multiplication.
Parameters in curly braces { } are optional.