Math functions

NAME	DESCRIPTION
ABS	Returns the absolute value of a number, a number without its sign
AVERAGE	Returns the average of the arguments
AVERAGEIF	Returns the average of the filtered values that satisfy the given condition
AVERAGEEXNEG	Returns the average of the arguments excluding negatives
AVERAGEEXZERO	Returns the average of the arguments excluding zeros
AVERAGEEXZERONEG	Returns the average of the arguments excluding zeros and negatives
CEILING	Rounds a number to the nearest integer or to the nearest multiple of significance
COUNT	Counts the number of items in the list
COUNTIF	Returns the count of items that match the specified condition
DIVIDE	Returns the division of two values
EVEN	Rounds to the nearest higher even number
EXP	Returns e raised to the power of a given number
FLOOR	Rounds a number (towards zero) to the nearest specified multiple of significance
INDEXOF	Returns the index of the first occurrence of a number in an array of numbers
LOG	Returns the logarithm of a number to the base specified
MAX	Returns the largest number in a set of values
MIN	Returns the smallest number in a set of values
MROUND	The MROUND function rounds a number to the nearest multiple of a specified value.
NORMDIST	Calculates Normal distribution for a measure, mean, and standard deviation
NORMSDIST	Calculates the standard normal distribution for a measure, with a mean of 0 and a standard distribution of 1
NORMINV	Calculates the inverse normal distribution for a measure, mean, and standard deviation.
NORMSINV	Calculates the inverse standard normal distribution for a measure, with a mean of 0, and standard deviation of 1.
ODD	Rounds to the nearest higher odd number
POWER	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
ROUNDDOWN	The ROUNDDOWN function always rounds a number down, toward zero
ROUNDUP	The ROUNDUP function always rounds a number up, away from zero
SQRT	Returns the square root of a number
SUM	Returns the sum of all the numbers in the argument
PCT	Used for a percentage calculation

Finance Function

PMT	Calculates the payment for a loan based on constant payments and a constant interest rate