Database Reference
In-Depth Information
TABle B-11
Math and Trig Functions
FuNCTIoN
DESCrIPTIoN
ABS(<
number
>)
Returns the absolute value of a
number.
CEILING(<
number
>,
<
significance
>)
Rounds a number up, to the nearest
integer or to the nearest multiple of
significance.
CURRENCY(<
value
>)
Evaluates the argument and returns
the result as currency data type.
Performs division and returns alter-
nate result or
BLANK()
on division by
0.
Alternateresult
(optional) is the
value returned when division by zero
results in an error.
DIVIDE(<
numerator
>,
<
denominator
>,
<
alternateresult
>)
EXP(<
number
>)
Returns
e
raised to the power of a
given number. The constant
e
equals
2.71828182845904, the base of the
natural logarithm.
FACT(<
number
>)
Returns the factorial of a number,
equal to the series 1*2*3*...* , ending
in the given number.
FLOOR(<
number
>, <
significance
>)
Rounds a number down, toward zero,
to the nearest multiple of significance.
INT(<
number
>)
Rounds a number down to the near-
est integer.
LN(<
number
>)
Returns the natural logarithm of a
number. Natural logarithms are based
on the constant e (2.71828182845904).
LOG(<
number
>, <
base
>)
Returns the logarithm of a number to
the base you specify.
LOG10(<
number
>)
Returns the base-10 logarithm of a
number.
MOD(<
number
>, <
divisor
>)
Returns the remainder after a num-
ber is divided by a divisor. The result
always has the same sign as the
divisor.
MROUND(<
number
>, <
multiple
>)
Returns a number rounded to the
desired multiple.
PI()
Returns the value of Pi,
3.14159265358979, accurate to 15
digits.
POWER(<
number
>, <
power
>)
Returns the result of a number raised
to a power.