Math functions

Math functions help you perform numerical calculations, statistical analysis, rounding operations, and financial computations in reports. These functions can be used to aggregate values, apply mathematical operations, generate random numbers, and evaluate statistical distributions.

In Plan, math functions help you create calculations for scenarios such as variance analysis, percentage calculations, forecasting, rounding, and financial modeling.

In this category

Function	Description
ABS	Returns the absolute value of a number without its sign.
AVERAGE	Returns the average of the specified values.
AVERAGEEXNEG	Returns the average of values excluding negative numbers.
AVERAGEEXZERO	Returns the average of values excluding zeros.
AVERAGEEXZERONEG	Returns the average of values excluding zeros and negative numbers.
CEILING	Rounds a number up to the nearest integer or specified multiple.
COUNT	Returns the count of values in a list.
COUNTIF	Returns the count of values that satisfy a specified condition.
DIVIDE	Returns the result of dividing one value by another.
EVEN	Rounds a number up to the nearest even integer.
EXP	Returns e raised to the power of a specified number.
FLOOR	Rounds a number down to the nearest specified multiple.
INDEXOF	Returns the index of the first occurrence of a value in a list.
LOG	Returns the logarithm of a number to a specified base.
MAX	Returns the largest value in a list.
MIN	Returns the smallest value in a list.
MROUND	Rounds a number to the nearest multiple of a specified value.
NORMDIST	Returns the normal distribution for a specified value, mean, and standard deviation.
NORMSDIST	Returns the standard normal distribution for a specified value, with a mean of 0 and a standard deviation of 1.
NORMINV	Returns the inverse normal distribution for a specified value, mean, and standard deviation.
NORMSINV	Returns the inverse standard normal distribution for a specified value, with a mean of 0 and a standard deviation of 1.
ODD	Rounds a number up to the nearest odd integer.
POWER	Returns the result of a number raised to a specified power.
RAND	Returns a random number between 0 and 1.
RANDBETWEEN	Returns a random number between two specified 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.
SQRT	Returns the square root of a number.
SUM	Returns the sum of the specified values.
PCT	Returns the percentage value for a calculation.

Finance Function

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