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.
Search WWH ::




Custom Search