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
LARGE	Returns the nth largest number from a list of values
LOG	Returns the logarithm of a number to the base specified
ODD	Rounds off an input number and returns the nearest higher odd number.
MAX	Returns the largest number in a set of values
MIN	Returns the smallest number in a set of values
MOD	Divides two numbers and returns the remainder
MROUND	Rounds a number to the nearest multiple of a specified value.
NUMBERVALUE	Converts text to a number
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
PCT	Used for a percentage calculation
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	Rounds a number down, toward zero
ROUNDUP	Rounds a number up, away from zero
SMALL	Returns the nth smallest number from a list of values
SORT	Accepts a series of values and returns an array of the values sorted in ascending order.
SUBTRACT	Accepts a series of values, subtracts them, and returns a number.
SUM	Returns the sum of all the numbers in the argument
SQRT	Returns the square root of a number

Finance Function

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