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.
Try itStatistical (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.