Math functions*

NAMEDESCRIPTION

Returns the absolute value of a number, a number without its sign

Returns the average of the arguments

Returns the average of the filtered values that satisfy the given condition

Returns the average of the arguments excluding negatives

Returns the average of the arguments excluding zeros

Returns the average of the arguments excluding zeros and negatives

Rounds a number to the nearest integer or to the nearest multiple of significance

Counts the number of items in the list

Returns the count of items that match the specified condition

Returns the division of two values

Rounds to the nearest higher even number

Returns e raised to the power of a given number

Rounds a number (towards zero) to the nearest specified multiple of significance

Returns the logarithm of a number to the base specified

Returns the largest number in a set of values

Returns the smallest number in a set of values

ODD

Rounds to the nearest higher odd number

Returns the result of a number raised to a power

RAND

Returns a random number between 0 and 1

RANDBETWEEN

Returns a random number between two values

ROUND

Rounds a number to the specified number of decimal places

SQRT

Returns the square root of a number

SUM

Returns the sum of all the numbers in the argument

Used for a percentage calculation

Last updated