Math functions
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
This section is being updated. Some formulas and functions may not be currently available in the visuals or the docs. We appreciate your understanding and patience as we work to provide comprehensive information about these formulas and functions.
Last updated