Math Functions
- Boaz Raufman
ACOS()
acos(a) - Returns inverse cosinus of a.
Example:
acos(0) -> 1.5707963
ASIN()
asin(a) - Returns inverse sinus of a.
Example:
asin(1) -> 1.5707963
ATAN()
atan(a) - Returns inverse tangent of a.
Example:
atan(tan(1)) -> 1
ATAN2()
atan2(a,b) - Returns inverse tangent of a/b.
Example:
atan2(4,-3) -> -0.9272952
CEIL()
ceil(n) - Returns the smallest BIGINT that is greater than or equal to n.
Example:
ceil(1.7) -> 2
COS()
cos(r) - Returns cosinus of radians r.
Example:
cos(pi()/2) -> 0
DEGREES()
degrees(r) - Returns degrees of radians r (convert radians to degrees).
Example:
degrees(pi()/2) -> 90
EXP()
exp(a) - Returns exponential of argument a.
Example:
exp(1) -> 2.7182818
FLOOR()
floor(n) - Returns the largest BIGINT that is less than or equal to n.
Example:
floor(1.7) -> 1
LN()
ln(a) - Returns the natural logarithm of number a. Natural logarithms are based on the constant e.
Example:
ln(95) -> 4.5538769
LOG()
log(a) - Returns the natural logarithm of number a. Natural logarithms are based on the constant e.
Example:
log(95) -> 4.5538769
LOG10()
Log10(a) - Returns the natural logarithm of number a based on the constant 10.
Example:
log10(100) -> 2
RADIANS()
radians(d) - Returns radians of degrees d (convert degrees to radians).
Example:
radians(90) -> 1.5705963
ROUND()
round(n,d) - Rounds decimal number n to the number of decimals d specified. If d is omitted, the function will round the number to 0 decimal places.
Examples:
round(125.315) -> 125
round(125.315, 2) -> 125.32
round(125.315, -2) -> 100
PI()
pi() - Returns value of PI.
Example:
pi() -> 3.1415927
POW()
pow(a,b) - Returns a raised to the power of b (a^b).
Example:
pow(2,3) -> 8
SIGN()
sign(a) - Returns the sign of number a. The possible return value is -1 if the number is negative, 0 if the number is zero, or 1 if the number is positive.
Example:
sign(-2) -> -1
SIN()
sin(r) - Returns sinus of radians r.
Example:
sin(pi()/2) -> 1
SQRT()
sqrt(a) - Returns square root of a.
Example:
sqrt(4) -> 2
TAN()
tan(r) - Returns tangent of radians r.
Example:
tan(pi()/4) -> 1