NOTE: The terms 'x' and 'y' are placeholders. They can include any set of numbers and/or parameters, including common mathematical functions and IF functions that are linked into an via standard algebraic operations (addition, subtraction, multiplication and division).
The formula names are not case-sensitive.
FUNCTION
CALCULATES
pow(x, y)
The value of x to the power of y.
sqrt(x)
The positive square root of x.
hypotenuse(a, b)
In a right triangle with legs a and b, calculates the length of the hypotenuse when provided with the values of a and b.
fmod(x, y)
The remainder f of x divided by y, where x = ay + f for an integer a, and 0 ⋜ f < y.
FUNCTION
CALCULATES
sin(x)
The sine of x.
cos(x)
The cosine of x.
tan(x)
The tangent of x.
asin(x)
The arcsine of x — that is, the inverse function to the sine: if y is the sine of n, then n is the arcsine of y.
acos(x)
The arccosine of x — that is, the inverse function to the cosine: if y is the cosine of n, then n is the arccosine of y.
atan(x)
The arctangent of x — that is, the inverse function to the tangent: if y is the tangent of n, then n is the arctangent of y.
FUNCTION
CALCULATES
log(x)
The natural/Napierian (base e) logarithm of x.
log10(x)
The common (base 10) logarithm of x.
FUNCTION
RETURNS
max(x, y, ..., N)
The greatest value of the listed expressions. NOTE: You can use as many expressions for this function as you need.
min(x, y, ..., N)
The smallest value of the listed expressions. NOTE: You can use as many expressions for this function as you need.
argmin(x, y, ..., N)
The position of the lowest value of the listed expressions. NOTE: If the lowest value is present on multiple positions in the array, the function returns the first position in the left-to-right direction. For example, in the array argmin(12; 13; 12; 14), the function will return 1.
FUNCTION
WHAT IT DOES
round(x)
Rounds the computed value according to common rounding rules. Example: 23.49 becomes 23.00; 23.50 becomes 24.00.
roundup(x); ceil(x)
Rounds the computed value up to the next integer. Example: 23.01 becomes 24.00.
rounddown(x); floor(x)
Rounds the computed value down to the lower integer. Example: 23.99 becomes 23.00.