Functions Reference

FILEMAKER FUNCTIONS REFERENCE 171
Number functions
Number functions are used to manipulate numeric data.
Click a function name for details.
Abs
Purpose
Returns the absolute value of number.
Format
Abs(number)
Parameters
number - any numeric expression or field containing a numeric expression
This function Returns
Abs The absolute value (a positive number) of a number.
Ceiling A number rounded up to the next integer.
Combination The number of ways to uniquely choose a specified number of items from a set of
specified size.
Div An integer of the specified number divided by the divisor.
Exp The value of the constant e (the base of the natural logarithm, equal to 2.7182818)
raised to the power of a specified number.
Factorial The factorial of a specified number stopping at 1, or at a specified number
factorial.
Floor A number rounded down to the next lower integer.
Int The whole number (integer) part of the value you specify, without rounding.
Lg The base 2 logarithm of the specified number, which can be any positive value.
Ln The base-e (natural) logarithm of the specified number.
Log The common logarithm (base 10) of the specified number, which can be any
positive value.
Mod The remainder after a specified number is divided by divisor.
Random A random number between zero and one.
Round A number rounded off to the specified precision (number of decimal places).
SetPrecision Any math functions contained within the specified expression to the specified
digits of precision, if the math function supports extended precision.
Sign One of three possible values: -1 when the specified number is negative, 0 when
it's zero, and 1 when it's positive.
Sqrt The square root of a number.
Truncate A number truncated to the specified precision (number of decimal places), without
evaluating the value of the discarded digits.