Skip to content
On this page

📘 Functions

These are all functions you can use

🟢 Basic functions

NameDescription
ABS(value)Absolute (non-negative) value
CEILING(value)Rounds the given value an integer using the rounding mode CEILING (towards positive infinity)
FACT(base)Calculates the factorial of a base value
FLOOR(value)Rounds the given value an integer using the rounding mode FLOOR (towards negative infinity)
IF(condition, resultIfTrue, resultIfFalse)Conditional evaluation function. If condition is true, the resultIfTrue is returned, else the resultIfFalse value
LOG(value)The natural logarithm (base e) of a value
LOG10(value)The base 10 logarithm of a value
MAX(value, ...)Returns the maximum value of all parameters
MIN(value, ...)Returns the maximum value of all parameters
NOT(value)Boolean negation, equals as ! operator
RANDOM()Produces a random value between 0 and 1
ROUND(value, scale)Rounds the given value to the specified scale
SQRT(value)Square root function
SUM(value, ...)Returns the sum of all parameters

🟡 String functions

NameDescription
STR_CONTAINS(string, substring)Returns true, if the string contains the substring (case-insensitive)
STR_LOWER(value)Converts the given value to lower case
STR_UPPER(value)Converts the given value to upper case

🔴 Trigonometric functions

NameDescription
ACOS(value)Returns the arc-cosine (in degrees)
ACOSH(value)Returns the hyperbolic arc-cosine
ACOSR(value)Returns the arc-cosine (in radians)
ACOT(value)Returns the arc-co-tangent (in degrees)
ACOTH(value)Returns the hyperbolic arc-co-tangent (in degrees)
ACOTR(value)Returns the arc-co-tangent (in radians)
ASIN(value)Returns the arc-sine (in degrees)
ASINH(value)Returns the hyperbolic arc-sine
ASINR(value)Returns the arc-sine (in radians)
ATAN2(y, x)Returns the angle of atan2 (in degrees)
ATAN2R(y, x)Returns the angle of atan2 (in radians)
ATAN(value)Returns the arc-tangent (in degrees)
ATANH(value)Returns the hyperbolic arc-tangent
ATANR(value)Returns the arc-tangent (in radians)
COS(value)Returns the cosine of an angle (in degrees)
COSH(value)Returns the hyperbolic cosine of a value
COSR(value)Returns the cosine of an angle (in radians)
COT(value)Returns the co-tangent of an angle (in degrees)
COTH(value)Returns the hyperbolic co-tangent of a value
COTR(value)Returns the co-tangent of an angle (in radians)
CSC(value)Returns the co-secant of an angle (in degrees)
CSCH(value)Returns the hyperbolic co-secant of a value
CSCR(value)Returns the co-secant of an angle (in radians)
DEG(rad)Converts an angle measured in radians to an approximately equivalent angle measured in degrees
RAD(degrees)Converts an angle measured in degrees to an approximately equivalent angle measured in radians
SEC(value)Returns the secant of an angle (in degrees)
SECH(value)Returns the hyperbolic secant of an angle
SECR(value)Returns the secant of an angle (in radians)
SIN(value)Returns the sine of an angle (in degrees)
SINH(value)Returns the hyperbolic sine of a value
SINR(value)Returns the sine of an angle (in radians)
TAN(value)Returns the tangent of an angle (in degrees)
TANH(value)Returns the hyperbolic tangent of a value
TANR(value)Returns the tangent of an angle (in radians)