Returns the value at a given percentile of a dataset.

PERCENTILE(data, percentile)

Calculates r, the Pearson product-moment correlation coefficient of a dataset.

PEARSON(data_y, data_x)

Rounds one number to the nearest integer multiple of another.

MROUND(value, factor)

Returns a number associated with the type of data passed into the function.

TYPE(value)

Given a set of values and corresponding probabilities, calculates the probability that a value ch...

PROB(data, probabilities, low_limit, [high_limit])

Calculates the price of a security paying interest at maturity, based on expected yield.

PRICEMAT(settlement, maturity, issue, rate, yield, [day_count_convention])

Calculates the price of a discount (non-interest-bearing) security, based on expected yield.

PRICEDISC(settlement, maturity, discount, redemption, [day_count_convention])

Calculates the price of a security paying periodic interest, such as a US Treasury Bond, based on...

PRICE(settlement, maturity, rate, yield, redemption, frequency, [day_count_convention])

Calculates the payment on the principal of an investment based on constant-amount periodic paymen...

PPMT(rate, period, number_of_periods, present_value, [future_value], [end_or_beginning])

Returns a number raised to a power.

POWER(base, exponent)

Returns a number raised to a power.

POW(base, exponent)

Returns the value of the Poisson distribution function (or Poisson cumulative distribution functi...

POISSON.DIST(x, mean, [cumulative])

See POISSON.DIST

POISSON(x, mean, cumulative)

Calculates the periodic payment for an annuity investment based on constant-amount periodic payme...

PMT(rate, number_of_periods, present_value, [future_value], [end_or_beginning])

Returns the value of Pi to 14 decimal places.

PI()

The PHI function returns the value of the normal distribution with mean 0 and standard deviation 1..

PHI(x)

Returns the number of permutations for selecting a group of objects (with replacement) from a tot...

PERMUTATIONA(number, number_chosen)

Returns the number of ways to choose some number of objects from a pool of a given size of object...

PERMUT(n, k)

Returns the percentage rank (percentile) from 0 to 1 inclusive of a specified value in a dataset.

PERCENTRANK.INC(data, value, [significant_digits])

Returns the percentage rank (percentile) from 0 to 1 exclusive of a specified value in a dataset.

PERCENTRANK.EXC(data, value, [significant_digits])

Returns the percentage rank (percentile) of a specified value in a dataset.

PERCENTRANK(data, value, [significant_digits])

See PERCENTILE

PERCENTILE.INC(data, percentile)

Returns the value at a given percentile of a dataset, exclusive of 0 and 1..

PERCENTILE.EXC(data, percentile)

See MODE

MODE.SNGL(value1, [value2, ...])

Returns the most commonly occurring values in a dataset..

MODE.MULT(value1, value2)

Returns the most commonly occurring value in a dataset.

MODE(value1, [value2, ...])

Returns the result of the modulo operator, the remainder after a division operation.

MOD(dividend, divisor)

Calculates the matrix product of two matrices specified as arrays or ranges.

MMULT(matrix1, matrix2)

Calculates the modified internal rate of return on an investment based on a series of periodic ca...

MIRR(cashflow_amounts, financing_rate, reinvestment_return_rate)

Returns the multiplicative inverse of a square matrix specified as an array or range.

MINVERSE(square_matrix)

Returns the minute component of a specific time, in numeric format.

MINUTE(time)

Returns the difference of two numbers. Equivalent to the `-` operator.

MINUS(value1, value2)

Returns the minimum value in a range of cells, filtered by a set of criteria..

MINIFS(range, criteria_range1, criterion1, [criteria_range2, criterion2], …)

Returns the minimum numeric value in a dataset.

MINA(value1, value2)

Returns a section of a string starting at a given character and up to a specified number of bytes..

MIDB(string)

Calculates the modified Macaulay duration of a security paying periodic interest, such as a US Tr...

MDURATION(settlement, maturity, rate, yield, frequency, [day_count_convention])

Returns the matrix determinant of a square matrix specified as an array or range.

MDETERM(square_matrix)

Returns the maximum value in a range of cells, filtered by a set of criteria..

MAXIFS(range, criteria_range1, criterion1, [criteria_range2, criterion2], …)

Returns the maximum numeric value in a dataset.

MAXA(value1, value2)

Maps each value in the given arrays to a new value by application of a LAMBDA function to each va...

MAP(array1, [array2, ...], LAMBDA)

Returns an array of specified dimensions with values calculated by application of a LAMBDA function.

MAKEARRAY(rows, columns, LAMBDA)

Returns `TRUE` if the first argument is less than or equal to the second, and `FALSE` otherwise. ...

LTE(value1, value2)

Returns `TRUE` if the first argument is strictly less than the second, and `FALSE` otherwise. Equ...

LT(value1, value2)

Looks through a row or column for a key and returns the value of the cell in a result range locat...

LOOKUP(search_key, search_range|search_result_array, [result_range])

Returns the value of the log-normal cumulative distribution with given mean and standard deviatio...

LOGNORMDIST(x, mean, standard_deviation)

See LOGINV

LOGNORM.INV(x, mean, standard_deviation)

See LOGNORMDIST

LOGNORM.DIST(x, mean, standard_deviation)

See ERF

ERF.PRECISE(lower_bound, [upper_bound])