ABS

Source

ABS returns the absolute value of a given number.
Argument Type Default value Description
number Int Float Input number.

Returns Float The absolute value of a given number.

ACOS

Source

ACOS returns the arccosine, in radians, of a given number.
Argument Type Default value Description
number Int Float Input number.

Returns Float The arccosine, in radians, of a given number.

ASIN

Source

ASIN returns the arcsine, in radians, of a given number.
Argument Type Default value Description
number Int Float Input number.

Returns Float The arcsine, in radians, of a given number.

ATAN

Source

ATAN returns the arctangent, in radians, of a given number.
Argument Type Default value Description
number Int Float Input number.

Returns Float The arctangent, in radians, of a given number.

ATAN2

Source

ATAN2 returns the arc tangent of y/x, using the signs of the two to determine the quadrant of the return value.
Argument Type Default value Description
number1 Int Float Input number.
number2 Int Float Input number.

Returns Float The arc tangent of y/x, using the signs of the two to determine the quadrant of the return value.

AVERAGE

Source

AVERAGE Returns the average (arithmetic mean) of the values in array.
Argument Type Default value Description
array Int[] Float[] Array of numbers.

Returns Float The average of the values in array.

CEIL

Source

CEIL returns the least integer value greater than or equal to a given value.
Argument Type Default value Description
number Int Float Input number.

Returns Int The least integer value greater than or equal to a given value.

COS

Source

COS returns the cosine of a given number.
Argument Type Default value Description
number Int Float Input number.

Returns Float The cosine of a given number.

DEGREES

Source

DEGREES returns the angle converted from radians to degrees.
Argument Type Default value Description
number Int Float The input number.

Returns Float The angle in degrees

EXP

Source

EXP returns Euler’s constant (2.71828…) raised to the power of value.
Argument Type Default value Description
number Int Float Input number.

Returns Float Euler’s constant raised to the power of value.

EXP2

Source

EXP2 returns 2 raised to the power of value.
Argument Type Default value Description
number Int Float Input number.

Returns Float 2 raised to the power of value.

FLOOR

Source

FLOOR returns the greatest integer value less than or equal to a given value.
Argument Type Default value Description
number Int Float Input number.

Returns Int The greatest integer value less than or equal to a given value.

LOG

Source

LOG returns the natural logarithm of a given value.
Argument Type Default value Description
number Int Float Input number.

Returns Float The natural logarithm of a given value.

LOG10

Source

LOG10 returns the decimal logarithm of a given value.
Argument Type Default value Description
number Int Float Input number.

Returns Float The decimal logarithm of a given value.

LOG2

Source

LOG2 returns the binary logarithm of a given value.
Argument Type Default value Description
number Int Float Input number.

Returns Float The binary logarithm of a given value.

MAX

Source

MAX returns the greatest (arithmetic mean) of the values in array.
Argument Type Default value Description
array Int[] Float[] Array of numbers.

Returns Float The greatest of the values in array.

MEDIAN

Source

MEDIAN returns the median of the values in array.
Argument Type Default value Description
array Int[] Float[] Array of numbers.

Returns Float The median of the values in array.

MIN

Source

MIN returns the smallest (arithmetic mean) of the values in array.
Argument Type Default value Description
array Int[] Float[] Array of numbers.

Returns Float The smallest of the values in array.

PERCENTILE

Source

PERCENTILE returns the nth percentile of the values in a given array.
Argument Type Default value Description
array Int[] Float[] Array of numbers.
number Int A number which must be between 0 (excluded) and 100 (included).
method String "rank" “rank” or “interpolation”.

Returns Float The nth percentile, or null if the array is empty or only null values are contained in it or the percentile cannot be calculated.

PI

Source

PI returns Pi value.
Argument Type Default value Description

Returns Float Pi value.

POW

Source

POW returns the base to the exponent value.
Argument Type Default value Description
base Int Float The base value.
exp Int Float The exponent value.

Returns Float The exponentiated value.

RADIANS

Source

RADIANS returns the angle converted from degrees to radians.
Argument Type Default value Description
number Int Float The input number.

Returns Float The angle in radians.

RAND

Source

RAND return a pseudo-random number between 0 and 1.
Argument Type Default value Description
max Int Float Upper limit.
min Int Float Lower limit.

Returns Float A number greater than 0 and less than 1.

RANGE

Source

RANGE returns an array of numbers in the specified range, optionally with increments other than 1.
Argument Type Default value Description
start Int Float The value to start the range at (inclusive).
end Int Float The value to end the range with (inclusive).
step Int Float 1.0 How much to increment in every step.

Returns Int[] Float[] Array of numbers in the specified range, optionally with increments other than 1.

ROUND

Source

ROUND returns the nearest integer, rounding half away from zero.
Argument Type Default value Description
number Int Float Input number.

Returns Int The nearest integer, rounding half away from zero.

SIN

Source

SIN returns the sine of the radian argument.
Argument Type Default value Description
number Int Float Input number.

Returns Float The sin, in radians, of a given number.

SQRT

Source

SQRT returns the square root of a given number.
Argument Type Default value Description
value Int Float A number.

Returns Float The square root.

STDDEV_POPULATION

Source

STDDEV_POPULATION returns the population standard deviation of the values in a given array.
Argument Type Default value Description
numbers Int[] Float[] Array of numbers.

Returns Float The population standard deviation.

STDDEV_SAMPLE

Source

STDDEV_SAMPLE returns the sample standard deviation of the values in a given array.
Argument Type Default value Description
numbers Int[] Float[] Array of numbers.

Returns Float The sample standard deviation.

SUM

Source

SUM returns the sum of the values in a given array.
Argument Type Default value Description
numbers Int[] Float[] Array of numbers.

Returns Float The sum of the values.

TAN

Source

TAN returns the tangent of a given number.
Argument Type Default value Description
number Int Float A number.

Returns Float The tangent.

VARIANCE_POPULATION

Source

VARIANCE_POPULATION returns the population variance of the values in a given array.
Argument Type Default value Description
numbers Int[] Float[] Array of numbers.

Returns Float The population variance.

VARIANCE_SAMPLE

Source

VARIANCE_SAMPLE returns the sample variance of the values in a given array.
Argument Type Default value Description
numbers Int[] Float[] Array of numbers.

Returns Float The sample variance.