Math functions*
NAME | DESCRIPTION |
---|---|
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