Functions Reference

Chapter 9
|
Number functions 137
Chapter 9
Number functions
Number functions are used to manipulate numeric data.
Click a function name for details.
This function Returns
Abs, page 138 The absolute value (a positive number) of a number.
Ceiling, page 138 A number rounded up to the next integer.
Combination, page
139
The number of ways to uniquely choose a specified number of items from a set of
a specified size.
Div, page 139 An integer of the specified number divided by the divisor.
Exp, page 140 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, page 140 The factorial of a specified number stopping at 1, or at a specified number
factorial.
Floor, page 141 A number rounded down to the next lower integer.
Int, page 142 The whole number (integer) part of the value you specify, without rounding.
Lg, page 142 The base 2 logarithm of the specified number, which can be any positive value.
Ln, page 143 The base-e (natural) logarithm of the specified number.
Log, page 143 The common logarithm (base 10) of the specified number, which can be any
positive value.
Mod, page 144 The remainder after a specified number is divided by divisor.
Random, page 144 A random number between zero and one.
Round, page 145 A number rounded off to the specified precision (number of decimal places).
SetPrecision, page
146
Any math functions contained within the specified expression to the specified
digits of precision, if the math function supports extended precision.
Sign, page 146 One of three possible values: -1 when the specified number is negative, 0 when
it's zero, and 1 when it's positive.
Sqrt, page 147 The square root of a number.
Truncate, page 147 A number truncated to the specified precision (number of decimal places), without
evaluating the value of the discarded digits.