Applies ToExcel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2024 Excel 2024 for Mac Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2016

To get detailed information about a function, click its name in the first column.

Function

Description

AVEDEV function

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

AVERAGE function

Returns the average of its arguments

AVERAGEA function

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

AVERAGEIF function

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

AVERAGEIFS function

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

BETA.DIST function Excel 2010

Returns the beta cumulative distribution function

BETA.INV function Excel 2010

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

BINOM.DIST function Excel 2010

Returns the individual term binomial distribution probability

BINOM.DIST.RANGE function Excel 2013

Returns the probability of a trial result using a binomial distribution

BINOM.INV function Excel 2010

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

CHISQ.DIST function Excel 2010

Returns the cumulative beta probability density function

CHISQ.DIST.RT function Excel 2010

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

CHISQ.INV function Excel 2010

Returns the cumulative beta probability density function

CHISQ.INV.RT function Excel 2010

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

CHISQ.TEST function Excel 2010

Returns the test for independence

CONFIDENCE.NORM function Excel 2010

Returns the confidence interval for a population mean

CONFIDENCE.T function Excel 2010

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

CORREL function

Returns the correlation coefficient between two data sets

COUNT function

Counts how many numbers are in the list of arguments

COUNTA function

Counts how many values are in the list of arguments

COUNTBLANK function

Counts the number of blank cells within a range

COUNTIF function

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

COUNTIFS function

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

COVARIANCE.P function Excel 2010

Returns covariance, the average of the products of paired deviations

COVARIANCE.S function Excel 2010

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

DEVSQ function

Returns the sum of squares of deviations

EXPON.DIST function Excel 2010

Returns the exponential distribution

F.DIST function Excel 2010

Returns the F probability distribution

F.DIST.RT function Excel 2010

Returns the F probability distribution

F.INV function Excel 2010

Returns the inverse of the F probability distribution

F.INV.RT function Excel 2010

Returns the inverse of the F probability distribution

F.TEST function Excel 2010

Returns the result of an F-test

FISHER function

Returns the Fisher transformation

FISHERINV function

Returns the inverse of the Fisher transformation

FORECAST function

Returns a value along a linear trend

Note: In Excel 2016, this function is replaced with FORECAST.LINEAR as part of the new Forecasting functions, but it's still available for compatibility with earlier versions.

FORECAST.ETS function Excel 2016

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

FORECAST.ETS.CONFINT function Excel 2016

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

FORECAST.ETS.SEASONALITY function Excel 2016

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

FORECAST.ETS.STAT function Excel 2016

Returns a statistical value as a result of time series forecasting

FORECAST.LINEAR function Excel 2016

Returns a future value based on existing values

FREQUENCY function

Returns a frequency distribution as a vertical array

GAMMA function Excel 2013

Returns the gamma function value

GAMMA.DIST function Excel 2010

Returns the gamma distribution

GAMMA.INV function Excel 2010

Returns the inverse of the gamma cumulative distribution

GAMMALN function

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

GAMMALN.PRECISE function Excel 2010

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

GAUSS function Excel 2013

Returns 0.5 less than the standard normal cumulative distribution

GEOMEAN function

Returns the geometric mean

GROWTH function

Returns values along an exponential trend

HARMEAN function

Returns the harmonic mean

HYPGEOM.DIST function

Returns the hypergeometric distribution

INTERCEPT function

Returns the intercept of the linear regression line

KURT function

Returns the kurtosis of a data set

LARGE function

Returns the k-th largest value in a data set

LINEST function

Returns the parameters of a linear trend

LOGEST function

Returns the parameters of an exponential trend

LOGNORM.DIST function Excel 2010

Returns the cumulative lognormal distribution

LOGNORM.INV function Excel 2010

Returns the inverse of the lognormal cumulative distribution

MAX function

Returns the maximum value in a list of arguments

MAXA function

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

MAXIFS function Excel 2016

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

MEDIAN function

Returns the median of the given numbers

MIN function

Returns the minimum value in a list of arguments

MINIFS function Excel 2016

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

MINA function

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

MODE.MULT function Excel 2010

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

MODE.SNGL function Excel 2010

Returns the most common value in a data set

NEGBINOM.DIST function Excel 2010

Returns the negative binomial distribution

NORM.DIST function Excel 2010

Returns the normal cumulative distribution

NORM.INV function Excel 2010

Returns the inverse of the normal cumulative distribution

NORM.S.DIST function Excel 2010

Returns the standard normal cumulative distribution

NORM.S.INV function Excel 2010

Returns the inverse of the standard normal cumulative distribution

PEARSON function

Returns the Pearson product moment correlation coefficient

PERCENTILE.EXC function Excel 2010

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

PERCENTILE.INC function Excel 2010

Returns the k-th percentile of values in a range

PERCENTRANK.EXC function Excel 2010

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

PERCENTRANK.INC function Excel 2010

Returns the percentage rank of a value in a data set

PERMUT function

Returns the number of permutations for a given number of objects

PERMUTATIONA function Excel 2013

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

PHI function Excel 2013

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

POISSON.DIST function Excel 2010

Returns the Poisson distribution

PROB function

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

QUARTILE.EXC function Excel 2010

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

QUARTILE.INC function Excel 2010

Returns the quartile of a data set

RANK.AVG function Excel 2010

Returns the rank of a number in a list of numbers

RANK.EQ function Excel 2010

Returns the rank of a number in a list of numbers

RSQ function

Returns the square of the Pearson product moment correlation coefficient

SKEW function

Returns the skewness of a distribution

SKEW.P function Excel 2013

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

SLOPE function

Returns the slope of the linear regression line

SMALL function

Returns the k-th smallest value in a data set

STANDARDIZE function

Returns a normalized value

STDEV.P function Excel 2010

Calculates standard deviation based on the entire population

STDEV.S function Excel 2010

Estimates standard deviation based on a sample

STDEVA function

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

STDEVPA function

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

STEYX function

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

T.DIST function Excel 2010

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

T.DIST.2T function Excel 2010

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

T.DIST.RT function Excel 2010

Returns the Student's t-distribution

T.INV function Excel 2010

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

T.INV.2T function Excel 2010

Returns the inverse of the Student's t-distribution

T.TEST function Excel 2010

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

TREND function

Returns values along a linear trend

TRIMMEAN function

Returns the mean of the interior of a data set

VAR.P function Excel 2010

Calculates variance based on the entire population

VAR.S function Excel 2010

Estimates variance based on a sample

VARA function

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

VARPA function

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

WEIBULL.DIST function Excel 2010

Returns the Weibull distribution

Z.TEST function Excel 2010

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

Important: The calculated results of formulas and some Excel worksheet functions may differ slightly between a Windows PC using x86 or x86-64 architecture and a Windows RT PC using ARM architecture. Learn more about the differences.

Related Topics

Excel functions (by category) Excel functions (alphabetical)

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.