Mathematical functions

The following table describes the supported mathematical functions.

Function Description
acos(X) Returns the arccosine of X in radians.
acosh(X) Returns the hyperbolic arccosine of X.
asin(X) Returns the arcsine of X in radians.
asinh(X) Returns the hyperbolic arcsine of X.
atan(X) Returns the arctangent of X in radians.
atan2(Y,X) Returns the arctangent of Y/X in radians.
The result is placed into the correct quadrant depending on the signs of X and Y.
atanh(X) Returns the hyperbolic arctangent of X.
ceil(X) Returns the smallest integer greater than or equal to X.
ceiling(X) Alias for ceil(X).
cos(X) Returns the cosine of X, where X is in radians.
cosh(X) Returns the hyperbolic cosine of X.
degrees(X) Converts X from radians to degrees.
exp(X) Returns e (≈2.71828) raised to the power of X.
floor(X) Returns the largest integer less than or equal to X.
ln(X) Returns the natural logarithm of X.
log(X) Returns the base-10 logarithm of X.
log10(X) Alias for log(X).
log(B,X) Returns the logarithm of X to base B.
log2(X) Returns the base-2 logarithm of X.
mod(X,Y) Returns the remainder after dividing X by Y (works with non-integer arguments).
pi() Returns an approximation of π (3.14159…).
pow(X,Y) Returns X raised to the power of Y.
power(X, Y) Alias for pow(X, Y).
radians(X) Converts X from degrees to radians.
sin(X) Returns the sine of X (X in radians).
sinh(X) Returns the hyperbolic sine of X.
sqrt(X) Returns the square root of X (NULL if X is negative).
tan(X) Returns the tangent of X (X in radians).
tanh(X) Returns the hyperbolic tangent of X.
trunc(X) Returns the integer part of X rounding it toward zero.