math

ABS

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

Updated on : 27 May 2022

Acos

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

Updated on : 27 May 2022

Acosec

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

Updated on : 27 May 2022

Acosh

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

Updated on : 27 May 2022

Acot

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

Updated on : 27 May 2022

Acoth

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

Updated on : 27 May 2022

Asec

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

Updated on : 27 May 2022

Asin

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

Updated on : 27 May 2022

Asinh

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

Updated on : 27 May 2022

Atan

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

Updated on : 27 May 2022

Atan2

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

Updated on : 27 May 2022

Atanh

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

Updated on : 27 May 2022

Ceil

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

Updated on : 27 May 2022

Combin

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

Updated on : 27 May 2022

Combina

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...

Updated on : 27 May 2022

Cos

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

Updated on : 27 May 2022

Cosec

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

Updated on : 27 May 2022

Cosech

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

Updated on : 27 May 2022

Cosh

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

Updated on : 27 May 2022

Cot

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

Updated on : 27 May 2022

Coth

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

Updated on : 27 May 2022

Degrees

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

Updated on : 27 May 2022

Div

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

Updated on : 27 May 2022

Divide

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

Updated on : 27 May 2022

Euler

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

Updated on : 27 May 2022

Even

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

Updated on : 27 May 2022

Exp

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

Updated on : 27 May 2022

Factorial

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

Updated on : 27 May 2022

Floor

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

Updated on : 27 May 2022

Greatest_commmon_divisor

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

Updated on : 27 May 2022

Hypot

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

Updated on : 27 May 2022

Is_even

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

Updated on : 27 May 2022

Is_nan

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

Updated on : 27 May 2022

Is_odd

Updated on : 27 May 2022

Least_common_multiple

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

Updated on : 27 May 2022

In

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

Updated on : 27 May 2022

Log

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

Updated on : 27 May 2022

Log2

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

Updated on : 27 May 2022

Log10

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

Updated on : 27 May 2022

Max

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

Updated on : 27 May 2022

Min

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

Updated on : 27 May 2022

Mod

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

Updated on : 27 May 2022

Multinominal

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

Updated on : 27 May 2022

Multiply

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

Updated on : 27 May 2022

Odd

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

Updated on : 27 May 2022

Pi

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

Updated on : 27 May 2022

Polynomial

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...

Updated on : 27 May 2022

Power

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

Updated on : 27 May 2022

Product

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

Updated on : 27 May 2022

Radians

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

Updated on : 27 May 2022

Random_array

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

Updated on : 27 May 2022

Random_integer_between

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 ...

Updated on : 27 May 2022

Random_number_between

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

Updated on : 27 May 2022

Random

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

Updated on : 27 May 2022

Sec

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

Updated on : 27 May 2022

Sech

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

Updated on : 27 May 2022

Sequence

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

Updated on : 27 May 2022

Series_sum

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

Updated on : 27 May 2022

Sign

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

Updated on : 27 May 2022

Sin

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

Updated on : 27 May 2022

Sinh

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

Updated on : 27 May 2022

Sqrt_pi

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

Updated on : 27 May 2022

Sqrt

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

Updated on : 27 May 2022

Sum_squared

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

Updated on : 27 May 2022

Sum

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

Updated on : 27 May 2022

Tan

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

Updated on : 27 May 2022

Tanh

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

Updated on : 27 May 2022