Functions Reference

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