# Mathematical Functions

Function Return Type Description
ABS([number] x) Same as input Returns the absolute value of x.
ACOS([number] x) Double Calculates the arccosine of x in radians.
ASIN([number] x) Double Calculates the arcsine of x in radians.
ATAN([number] x) Double Calculates the arctangent of x in radians.
CBRT([number] x) Float Calculates the cube root of x.
CEILING([number] x) Same as input Returns the nearest whole number greater than x.
COS([number] x) Double Calculates the cosine of x, where x is given in radians.
COSH([number] x) Double Calculates the hyperbolic cosine of x.
COT([number] x) Double Calculates the cotangent of x, where x is given in radians.
DEGREES([number] x) Float Converts the value in radians given by x to degrees.
E() Float Returns the mathematical constant e.
EXP([number] x) Float Calculates the value of the constant e raised to the power of x.
FLOOR([number] x) Same as input Returns the nearest whole number less than x.
LOG([number] x) Float Calculates the natural logarithm of x.
LOG([number] x, [number] y) Float Calculates the log base x of y.
LOG10([number] x) Float Calculates the log base 10 of x.
LSHIFT([number] x, [number] y) Same as input Returns the binary representation of x shifted to the left by y digits.
MOD([number] x, [number] y) number Calculates the modulus of x and y (e.g. x % y).
PI Float Returns the value of the mathematical constant pi.
POW([number] x, [number] y) Float Calculates the x to the power of y.
RADIANS([number] x) Float Converts the value in degrees given by x to radians.
RAND() Float Generates a random number greater than or equal to 0 and less than 1. This random number will be the same for each entry.
RANDOM() Float Generates a random number greater than or equal to 0 and less than 1. A new random number will made for each entry.
ROUND([number] x) Same as input Returns the whole number nearest the value x.
RSHIFT([number] x, [number] y) Same as input Returns the binary representation of x shifted to the right by y digits.
SIGN([number] x) Integer Returns the sign of x (e.g. either -1 or +1).
SIN([number] x) Double Calculates the sine of x, where x is given in radians.
SINH([number] x) Double Calculates the hyperbolic sine of x.
SQRT([number] x) Same as input Calculates the square root of x.
TAN([number] x) Double Calculates the tangent of x, where x is given in radians.
TANH([number] x) Double Calculates the hyperbolic tangent of x.
TRUNC([number] x, [optional number] y) Same as input Keeps the first y digits to right of x's decimal point. If the second argument is omitted then y = 1.