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 index of the first occurrence of a number in an array of numbers
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
The MROUND function rounds a number to the nearest multiple of a specified value.
Calculates Normal distribution for a measure, mean, and standard deviation
Calculates the standard normal distribution for a measure, with a mean of 0 and a standard distribution of 1
Calculates the inverse normal distribution for a measure, mean, and standard deviation.
Calculates the inverse standard normal distribution for a measure, with a mean of 0, and standard deviation of 1.
Rounds to the nearest higher odd number
Returns the result of a number raised to a power
Returns a random number between 0 and 1
Returns a random number between two values
Rounds a number to the specified number of decimal places
The ROUNDDOWN function always rounds a number down, toward zero
The ROUNDUP function always rounds a number up, away from zero
Returns the square root of a number
Returns the sum of all the numbers in the argument
Used for a percentage calculation
Finance Function
Calculates the payment for a loan based on constant payments and a constant interest rate