Mathematical Functions
|
Previous Top Next |
Function
|
Description
|
ABS
|
Returns the absolute value of a number
|
ACOS
|
Returns the inverse cosine of a given number
|
ASIN
|
Returns the inverse sine of a given number
|
ATAN
|
Returns the arctangent of a number
|
CEIL
|
Rounds variables up toward positive infinity
|
COS
|
Returns the cosine of an angle
|
EXP
|
Returns the exponential of a number
|
FLOOR
|
Rounds variables toward negative infinity
|
LOG
|
Returns the natural log of a real expression
|
POWER
|
Raises Base to any power
|
RAND
|
Generates random numbers within a specified range
|
ROUND
|
Returns the value of a number rounded to the specified length or precision.
|
SIGN
|
Indicates whether a numeric value is positive, negative, or zero
|
SIN
|
Returns the sine of the angle in radians
|
SQR
|
Returns the square of a number
|
SQRT
|
Returns the square root of a number
|
ABS(-2.9) returns 2.9
|
|
|
ACOS(1) returns 0
|
|
|
ASIN(0) returns 0
|
|
|
ATAN(0) returns 0
|
|
|
CEIL(11.22) returns 12
|
|
|
COS(-3.15) returns -0.999964658471342
|
|
|
EXP(3) returns 20.0855369231877
|
|
|
FLOOR(3.67) returns 3
|
|
|
LOG(20) returns 2.99573227355399
|
|
|
POWER(3,2) returns 9
|
|
|
RAND(10) may return 0..9
|
|
|
HalfEven - Round to nearest or to even whole number. ("Banker's Rounding")
|
HalfPos - Round to nearest or toward positive.
|
HalfNeg - Round to nearest or toward negative.
|
HalfDown - Round to nearest or toward zero.
|
HalfUp - Round to nearest or away from zero.
|
RndNeg - Round toward negative. (i.e. Floor)
|
RndPos - Round toward positive. (i.e. Ceil)
|
RndDown - Round toward zero. (i.e. Trunc)
|
RndUp - Round away from zero.
|
ROUND(4.6) returns 5
|
ROUND(4.56, 1) returns 4.6
|
ROUND(1.235, 2) returns 1.24
|
ROUND(1.245, 2) returns 1.24
|
ROUND(1.245, 2, HalfPos) returns 1.25
|
|
|
SIGN(10) returns 1
|
|
|
SIN(3) returns 0.141120008059867
|
|
|
SQR(3) returns 9
|
|
|
SQRT(9) returns 3
|
|
|