Excel functions

Every Excel function (476), organized by category. Arguments in [brackets] are optional.

Formula Explainer · Paste any formula and see it broken down step by step. Free.

Statistical (110)

=AVEDEV(number1, [number2], ...)

Returns the average of the absolute deviations of data points from their mean.

=AVERAGE(number1, [number2], ...)

Returns the average of its arguments.

=AVERAGEA(value1, [value2], ...)

Returns the average of its arguments, including numbers, text, and logical values.

=AVERAGEIF(range, criteria, [average_range])

Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria.

=AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)

Returns the average (arithmetic mean) of all cells that meet multiple criteria.

=BETA.DIST(x, alpha, beta, cumulative, [A], [B])

Returns the beta cumulative distribution function.

=BETA.INV(probability, alpha, beta, [A], [B])

Returns the inverse of the cumulative distribution function for a specified beta distribution.

=BINOM.DIST(number_s, trials, probability_s, cumulative)

Returns the individual term binomial distribution probability.

=BINOM.DIST.RANGE(trials, probability_s, number_s, [number_s2])

Returns the probability of a trial result using a binomial distribution.

=BINOM.INV(trials, probability_s, alpha)

Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value.

=CHISQ.DIST(x, deg_freedom, cumulative)

Returns the cumulative beta probability density function.

=CHISQ.DIST.RT(x, deg_freedom)

Returns the one-tailed probability of the chi-squared distribution.

=CHISQ.INV(probability, deg_freedom)

Returns the cumulative beta probability density function.

=CHISQ.INV.RT(probability, deg_freedom)

Returns the inverse of the one-tailed probability of the chi-squared distribution.

=CHISQ.TEST(actual_range, expected_range)

Returns the test for independence.

=CONFIDENCE.NORM(alpha, standard_dev, size)

Returns the confidence interval for a population mean.

=CONFIDENCE.T(alpha, standard_dev, size)

Returns the confidence interval for a population mean, using a Student's t distribution.

=CORREL(array1, array2)

Returns the correlation coefficient between two data sets.

=COUNT(value1, [value2], ...)

Counts how many numbers are in the list of arguments.

=COUNTA(value1, [value2], ...)

Counts how many values are in the list of arguments.

=COUNTBLANK(range)

Counts the number of blank cells within a range.

=COUNTIF(range, criteria)

Counts the number of cells within a range that meet the given criteria.

=COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]...)

Counts the number of cells within a range that meet multiple criteria.

=COVARIANCE.P(array1, array2)

Returns covariance, the average of the products of paired deviations.

=COVARIANCE.S(array1, array2)

Returns the sample covariance, the average of the products deviations for each data point pair in two data sets.

=DEVSQ(number1, [number2], ...)

Returns the sum of squares of deviations.

=EXPON.DIST(x, lambda, cumulative)

Returns the exponential distribution.

=F.DIST(x, deg_freedom1, deg_freedom2, cumulative)

Returns the F probability distribution.

=F.DIST.RT(x, deg_freedom1, deg_freedom2)

Returns the F probability distribution.

=F.INV(probability, deg_freedom1, deg_freedom2)

Returns the inverse of the F probability distribution.

=F.INV.RT(probability, deg_freedom1, deg_freedom2)

Returns the inverse of the F probability distribution.

=F.TEST(array1, array2)

Returns the result of an F-test.

=FISHER(x)

Returns the Fisher transformation.

=FISHERINV(y)

Returns the inverse of the Fisher transformation.

=FORECAST.ETS(target_date, values, timeline, [seasonality], [data_completion], [aggregation])

Returns a future value based on existing (historical) values by using the AAA version of the Exponential Smoothing (ETS) algorithm.

=FORECAST.ETS.CONFINT(target_date, values, timeline, [confidence_level], [seasonality], [data_completion], [aggregation])

Returns a confidence interval for the forecast value at the specified target date.

=FORECAST.ETS.SEASONALITY(values, timeline, [data_completion], [aggregation])

Returns the length of the repetitive pattern Excel detects for the specified time series.

=FORECAST.ETS.STAT(values, timeline, statistic_type, [seasonality], [data_completion], [aggregation])

Returns a statistical value as a result of time series forecasting.

=FORECAST.LINEAR(x, known_y's, known_x's)

Returns a future value based on existing values.

=FREQUENCY(data_array, bins_array)

Returns a frequency distribution as a vertical array.

=GAMMA(number)

Returns the Gamma function value.

=GAMMA.DIST(x, alpha, beta, cumulative)

Returns the gamma distribution.

=GAMMA.INV(probability, alpha, beta)

Returns the inverse of the gamma cumulative distribution.

=GAMMALN(x)

Returns the natural logarithm of the gamma function, Γ(x).

=GAMMALN.PRECISE(x)

Returns the natural logarithm of the gamma function, Γ(x).

=GAUSS(z)

Returns 0.5 less than the standard normal cumulative distribution.

=GEOMEAN(number1, [number2], ...)

Returns the geometric mean.

=GROWTH(known_y's, [known_x's], [new_x's], [const])

Returns values along an exponential trend.

=HARMEAN(number1, [number2], ...)

Returns the harmonic mean.

=HYPGEOM.DIST(sample_s, number_sample, population_s, number_pop, cumulative)

Returns the hypergeometric distribution.

=INTERCEPT(known_y's, known_x's)

Returns the intercept of the linear regression line.

=KURT(number1, [number2], ...)

Returns the kurtosis of a data set.

=LARGE(array, k)

Returns the k-th largest value in a data set.

=LINEST(known_y's, [known_x's], [const], [stats])

Returns the parameters of a linear trend.

=LOGEST(known_y's, [known_x's], [const], [stats])

Returns the parameters of an exponential trend.

=LOGNORM.DIST(x, mean, standard_dev, cumulative)

Returns the cumulative lognormal distribution.

=LOGNORM.INV(probability, mean, standard_dev)

Returns the inverse of the lognormal cumulative distribution.

=MAX(number1, [number2], ...)

Returns the maximum value in a list of arguments.

=MAXA(value1, [value2], ...)

Returns the maximum value in a list of arguments, including numbers, text, and logical values.

=MAXIFS(max_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)

Returns the maximum value among cells specified by a given set of conditions or criteria.

=MEDIAN(number1, [number2], ...)

Returns the median of the given numbers.

=MIN(number1, [number2], ...)

Returns the minimum value in a list of arguments.

=MINA(value1, [value2], ...)

Returns the smallest value in a list of arguments, including numbers, text, and logical values.

=MINIFS(min_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)

Returns the minimum value among cells specified by a given set of conditions or criteria.

=MODE.MULT(number1, [number2], ...)

Returns a vertical array of the most frequently occurring, or repetitive values in an array or range of data.

=MODE.SNGL(number1, [number2], ...)

Returns the most common value in a data set.

=NEGBINOM.DIST(number_f, number_s, probability_s, cumulative)

Returns the negative binomial distribution.

=NORM.DIST(x, mean, standard_dev, cumulative)

Returns the normal cumulative distribution.

=NORM.INV(probability, mean, standard_dev)

Returns the inverse of the normal cumulative distribution.

=NORM.S.DIST(z, cumulative)

Returns the standard normal cumulative distribution.

=NORM.S.INV(probability)

Returns the inverse of the standard normal cumulative distribution.

=PEARSON(array1, array2)

Returns the Pearson product moment correlation coefficient.

=PERCENTILE.EXC(array, k)

Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive.

=PERCENTILE.INC(array, k)

Returns the k-th percentile of values in a range.

=PERCENTRANK.EXC(array, x, [significance])

Returns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set.

=PERCENTRANK.INC(array, x, [significance])

Returns the percentage rank of a value in a data set.

=PERMUT(number, number_chosen)

Returns the number of permutations for a given number of objects.

=PERMUTATIONA(number, number-chosen)

Returns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects.

=PHI(x)

Returns the value of the density function for a standard normal distribution.

=POISSON.DIST(x, mean, cumulative)

Returns the Poisson distribution.

=PROB(x_range, prob_range, [lower_limit], [upper_limit])

Returns the probability that values in a range are between two limits.

=QUARTILE.EXC(array, quart)

Returns the quartile of the data set, based on percentile values from 0..1, exclusive.

=QUARTILE.INC(array, quart)

Returns the quartile of a data set.

=RANK.AVG(number, ref, [order])

Returns the rank of a number in a list of numbers.

=RANK.EQ(number, ref, [order])

Returns the rank of a number in a list of numbers.

=RSQ(known_y's, known_x's)

Returns the square of the Pearson product moment correlation coefficient.

=SKEW(number1, [number2], ...)

Returns the skewness of a distribution.

=SKEW.P(number 1, [number 2], ...)

Returns the skewness of a distribution based on a population: a characterization of the degree of asymmetry of a distribution around its mean.

=SLOPE(known_y's, known_x's)

Returns the slope of the linear regression line.

=SMALL(array, k)

Returns the k-th smallest value in a data set.

=STANDARDIZE(x, mean, standard_dev)

Returns a normalized value.

=STDEV.P(number1, [number2], ...)

Calculates standard deviation based on the entire population.

=STDEV.S(number1, [number2], ...)

Estimates standard deviation based on a sample.

=STDEVA(value1, [value2], ...)

Estimates standard deviation based on a sample, including numbers, text, and logical values.

=STDEVPA(value1, [value2], ...)

Calculates standard deviation based on the entire population, including numbers, text, and logical values.

=STEYX(known_y's, known_x's)

Returns the standard error of the predicted y-value for each x in the regression.

=T.DIST(x, deg_freedom, cumulative)

Returns the Percentage Points (probability) for the Student t-distribution.

=T.DIST.2T(x, deg_freedom)

Returns the Percentage Points (probability) for the Student t-distribution.

=T.DIST.RT(x, deg_freedom)

Returns the Student's t-distribution.

=T.INV(probability, deg_freedom)

Returns the t-value of the Student's t-distribution as a function of the probability and the degrees of freedom.

=T.INV.2T(probability, deg_freedom)

Returns the inverse of the Student's t-distribution.

=T.TEST(array1, array2, tails, type)

Returns the probability associated with a Student's t-test.

=TREND(known_y's, [known_x's], [new_x's], [const])

Returns values along a linear trend.

=TRIMMEAN(array, percent)

Returns the mean of the interior of a data set.

=VAR.P(number1, [number2], ...)

Calculates variance based on the entire population.

=VAR.S(number1, [number2], ...)

Estimates variance based on a sample.

=VARA(value1, [value2], ...)

Estimates variance based on a sample, including numbers, text, and logical values.

=VARPA(value1, [value2], ...)

Calculates variance based on the entire population, including numbers, text, and logical values.

=WEIBULL.DIST(x, alpha, beta, cumulative)

Returns the Weibull distribution.

=Z.TEST(array, x, [sigma])

Returns the one-tailed probability-value of a z-test.