math

Calculates the absolute value of the given number, i.e. if the number is negative, its positive value is returned. Function signature ABS(number: Number) => Number Examples

Calculates the inverse cosine or arccosine of the given number. The value is returned in radians. Function signature ACOS(number: Number) => Number Examples

Calculates the inverse cosecant or arccosecant of the given number. The value is returned in radians. Function signature ACOSEC(number: Number) => Number Examples

Calculates the inverse hyberbolic cosine of the given number. The value is returned in radians. Function signature ACOSH(number: Number) => Number Examples

Calculates the inverse cotangent or arccotangent of the given number. The value is returned in radians. Function signature ACOT(number: Number) => Number Examples

Calculates the inverse hyberbolic cotangent of the given number. The value is returned in radians. Function signature ACOTH(number: Number) => Number Examples

Calculates the inverse secant or arcsecant of the given number. The value is returned in radians. Function signature ASEC(number: Number) => Number Examples

Calculates the inverse sine of the given number. The value is returned in radians. Function signature ASIN(number: Number) => Number Examples

Calculates the inverse hyberbolic sine of the given number. The value is returned in radians. Function signature ASINH(number: Number) => Number Examples

Calculates the inverse tangent or arctangent of the given number. The value is returned in radians. Function signature ATAN(number: Number) => Number Examples

Calculates the angle between the vertical x-axis, and a line drawn between the given x/y coordinates and the origin. The value is returned in radians. Function signature ATAN2(numberx: Number, numbery: Number) => Number Examples

Calculates the hyberbolic arctangent of the given number. The value is returned in radians. Function signature ATANH(number: Number) => Number Examples

Rounds the given number up to the next integer. Function signature CEIL(number: Number) => Number Examples

Calculates the "n choose k" / nCk combinatorics function for the given parameters, returning the number of ways K objects can be chosen from a pool of N objects. Function signature COMBIN(n: Number, k: Number) => Number Examples

Calculates the "n choose k" / nCk combinatorics function for the given parameters, with object replacement. Returns the number of ways K objects can be chosen from a pool of N objects, with every chosen object returned to the pool after choosi...

Given an angle in radians, calculates its cosine. Function signature COS(number: Number) => Number Examples

Given an angle in radians, calculates its cosecant. Function signature COSEC(number: Number) => Number Examples

Given an angle in radians, calculates its hyberbolic cosecant. Function signature COSECH(number: Number) => Number Examples

Calculates the hyberbolic cosine for the given number. Function signature COSH(number: Number) => Number Examples

Given an angle in radians, calculates its cotangent. Function signature COT(number: Number) => Number Examples

Given an angle in radians, calculates its hyberbolic cotangent. Function signature COTH(number: Number) => Number Examples

Given an angle in radians, returns its value in degrees. Function signature DEGREES(number: Number) => Number Examples

Divides the first number parameter with the second one, truncating any decimal points and returning an integer.| Function signature DIV(dividend: Number, divisor: Number) => Number Examples

Divides the first number with the second one, returning an integer or a decimal number accordingly. Equivalent to the the / operator. Function signature DIVIDE(dividend: Number, divisor: Number) => Number Examples

Returns Euler's constant (the base of natural logarithms), approximately 2.718. Function signature EULER() => Number Examples

Returns the given number, rounded up to the nearest even integer. If the given number is an even integer, returns itself. Function signature EVEN(number: Number) => Number Examples

Returns Euler's constant, raised to the given power. Function signature EXP(number: Number) => Number Examples

Returns the factorial of the given number, i.e. value of the mathematical notation _n!_. Function signature FACTORIAL(number: Number) => Number Examples

Returns the given number, rounded down to the nearest integer. If the given number is an integer, returns itself. Function signature FLOOR(number: Number) => Number Examples

Given a list of numbers, calculates the greatest common divisor for them. Function signature GREATEST_COMMON_DIVISOR(list: Array) => Number Examples

Calculate the hypotenusea of a list of numbers, i.e. the square root of the sum of squares of the numbers. Function signature HYPOT(values: Array) => Number Examples

Returns true if the given number is even, false if it's odd. Function signature IS_EVEN(number: Number) => Boolean Examples

Returns true if the given number is NaN , a special "not a number" symbol. For example, dividing any number by 0 results in NaN . Function signature IS_NAN(number: Number) => Boolean Examples

Given a list of numbers, calculates the least common multiple for them. Function signature LEAST_COMMON_MULTIPLE(list: Array) => Number Examples

Calculates the natural logarithm for the given number, i.e. logarithm in base _e_ (Euler's number). Function signature LN(number: Number) => Number Examples

Given a number, calculates its logarithm in the given base. Function signature LOG(number: Number, base: Number) => Number Examples

Calculates the base 2 logarithm of the given number. Function signature LOG2(number: Number) => Number Examples

Calculates the base 10 logarithm of the given number. Function signature LOG10(number: Number) => Number Examples

Given a list of numbers, returns the highest number in the list. Function signature MAX(values: Array) => Number Examples

Given a list of numbers, returns the smallest number in the list. Function signature MIN(values: Array) => Number Examples

Given a dividend and a divisor, returns the result of the modulo operation. Function signature MOD(dividend: Number, divisor: Number) => Number Examples

Given a list of numbers, calculates the factorial of their sum, divided by the product of each number's factorial. Function signature MULTINOMIAL(values: Array) => Number Examples

Multiplies two numbers, returning their product. Equivalent to the * operator. Function signature MULTIPLY(multiplicand: Number, multiplier: Number) => Number Examples

Returns the given number, rounded up to the nearest odd integer. If the given number is an odd integer, returns itself. Function signature ODD(number: Number) => Number Examples

Returns the value of pi (the ratio of the circumference of a circle to its diameter) to 15 decimal places, i.e. 3.141592653589793 . Function signature PI() => Number Examples

Given a list of numbers such as \[a, b, c\] , calculates the sum c*x⁰ + b*x¹ + a*x² . If there are more elements in the list, the series is continued. If the given list is empty, returns 0. Function signature POLYNOMIAL(xvalue: Number, coef...

Calculates the value of the given number raised to the given power. Function signature POWER(base: Number, power: Number) => Number Examples

Given a list of numbers, calculate the product of multiplying the numbers with each other. Function signature PRODUCT(values: Array) => Number Examples

Given an angle in degrees, returns its value in radians. Function signature RADIANS(number: Number) => Number Examples

Generates a list of (pseudo) random numbers, each between 0 (inclusive) and 1 (exclusive), i.e. 0 ≤ n < 1. Function signature RANDOM_ARRAY(count: Number) => Array Examples

Given two integers, returns a random integer between them. The range is inclusive, meaning that the returned value may be equal to either the start or the end value. Function signature RANDOM_INTEGER_BETWEEN(min: Number, max: Number) => Number ...

Given two numbers, returns a random number between them. The lower number is inclusive and the higher number exclusive, i.e. a ≤ n < b. Function signature RANDOM_NUMBER_BETWEEN(min: Number, max: Number) => Number Examples

Returns a (pseudo) random number between 0 (inclusive) and 1 (exclusive), e.g. 0 ≤ n < 1. Function signature RANDOM() => Number Examples

Given an angle in radians, returns its secant. Function signature SEC(number: Number) => Number Examples

Given an angle in radians, returns its hyperbolic secant. Function signature SECH(number: Number) => Number Examples

Generates a list of sequential numbers, separated by the given step value. Function signature SEQUENCE(startnumber: Number, countnumber: Number, stepnumber: Number) => Array Examples

Calculates the sum of a power series. Given a list of numbers , and the constants , and , the sum is calculated using the formula: ...

Returns -1 if the parameter is a negative number, 1 if it is positive, and 0 if it is zero. Returns null if it's not a number. Function signature SIGN(number: Number) => Number Examples

Given an angle in radians, calculates its sine. Function signature SIN(number: Number) => Number Examples

Calculates the hyberbolic sine for the given number. Function signature SINH(number: Number) => Number Examples

Calculates the square root of the product of the given (positive) number and pi. Function signature SQRT_PI(number: Number) => Number Examples

Calculate the square root for the given number. Function signature SQRT(number: Number) => Number Examples

Given a list of numbers, returns the sum of the squares of the numbers. Function signature SUM_SQUARED(values: Array) => Number Examples

Given an array of numbers, calculates their sum. If the array is empty, returns 0. Function signature SUM(values: Array) => Number Examples

Given an angle in radians, calculates its tangent Function signature TAN(number: Number) => Number Examples

Calculates the hyberbolic tangent of the given number. Function signature TANH(number: Number) => Number Examples