| Function
| Description
|
| AVEDEV
| Returns the average of the absolute deviations of data points from their mean
|
| AVERAGE
| Returns the average of its arguments
|
| AVERAGEA
| Returns the average of its arguments, including numbers, text, and logical values
|
| AVERAGEIF
| Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria
|
| AVERAGEIFS
| Returns the average (arithmetic mean) of all cells that meet multiple criteria.
|
| BETADIST
| Returns the beta cumulative distribution function
|
| BETAINV
| Returns the inverse of the cumulative distribution function for a specified beta distribution
|
| BINOMDIST
| Returns the individual term binomial distribution probability
|
| CHIDIST
| Returns the one-tailed probability of the chi-squared distribution
|
| CHIINV
| Returns the inverse of the one-tailed probability of the chi-squared distribution
|
| CHITEST
| Returns the test for independence
|
| CONFIDENCE
| Returns the confidence interval for a population mean
|
| CORREL
| Returns the correlation coefficient between two data sets
|
| COUNT
| Counts how many numbers are in the list of arguments
|
| COUNTA
| Counts how many values are in the list of arguments
|
| COUNTBLANK
| Counts the number of blank cells within a range
|
| COUNTIF
| Counts the number of cells within a range that meet the given criteria
|
| COUNTIFS
| Counts the number of cells within a range that meet multiple criteria
|
| COVAR
| Returns covariance, the average of the products of paired deviations
|
| CRITBINOM
| Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value
|
| DEVSQ
| Returns the sum of squares of deviations
|
| EXPONDIST
| Returns the exponential distribution
|
| FDIST
| Returns the F probability distribution
|
| FINV
| Returns the inverse of the F probability distribution
|
| FISHER
| Returns the Fisher transformation
|
| FISHERINV
| Returns the inverse of the Fisher transformation
|
| FORECAST
| Returns a value along a linear trend
|
| FREQUENCY
| Returns a frequency distribution as a vertical array
|
| FTEST
| Returns the result of an F-test
|
| GAMMADIST
| Returns the gamma distribution
|
| GAMMAINV
| Returns the inverse of the gamma cumulative distribution
|
| GAMMALN
| Returns the natural logarithm of the gamma function, Γ(x)
|
| GEOMEAN
| Returns the geometric mean
|
| GROWTH
| Returns values along an exponential trend
|
| HARMEAN
| Returns the harmonic mean
|
| HYPGEOMDIST
| Returns the hypergeometric distribution
|
| INTERCEPT
| Returns the intercept of the linear regression line
|
| KURT
| Returns the kurtosis of a data set
|
| LARGE
| Returns the k-th largest value in a data set
|
| LINEST
| Returns the parameters of a linear trend
|
| LOGEST
| Returns the parameters of an exponential trend
|
| LOGINV
| Returns the inverse of the lognormal distribution
|
| LOGNORMDIST
| Returns the cumulative lognormal distribution
|
| MAX
| Returns the maximum value in a list of arguments
|
| MAXA
| Returns the maximum value in a list of arguments, including numbers, text, and logical values
|
| MEDIAN
| Returns the median of the given numbers
|
| MIN
| Returns the minimum value in a list of arguments
|
| MINA
| Returns the smallest value in a list of arguments, including numbers, text, and logical values
|
| MODE
| Returns the most common value in a data set
|
| NEGBINOMDIST
| Returns the negative binomial distribution
|
| NORMDIST
| Returns the normal cumulative distribution
|
| NORMINV
| Returns the inverse of the normal cumulative distribution
|
| NORMSDIST
| Returns the standard normal cumulative distribution
|
| NORMSINV
| Returns the inverse of the standard normal cumulative distribution
|
| PEARSON
| Returns the Pearson product moment correlation coefficient
|
| PERCENTILE
| Returns the k-th percentile of values in a range
|
| PERCENTRANK
| Returns the percentage rank of a value in a data set
|
| PERMUT
| Returns the number of permutations for a given number of objects
|
| POISSON
| Returns the Poisson distribution
|
| PROB
| Returns the probability that values in a range are between two limits
|
| QUARTILE
| Returns the quartile of a data set
|
| RANK
| Returns the rank of a number in a list of numbers
|
| RSQ
| Returns the square of the Pearson product moment correlation coefficient
|
| SKEW
| Returns the skewness of a distribution
|
| SLOPE
| Returns the slope of the linear regression line
|
| SMALL
| Returns the k-th smallest value in a data set
|
| STANDARDIZE
| Returns a normalized value
|
| STDEV
| Estimates standard deviation based on a sample
|
| STDEVA
| Estimates standard deviation based on a sample, including numbers, text, and logical values
|
| STDEVP
| Calculates standard deviation based on the entire population
|
| STDEVPA
| Calculates standard deviation based on the entire population, including numbers, text, and logical values
|
| STEYX
| Returns the standard error of the predicted y-value for each x in the regression
|
| TDIST
| Returns the Student's t-distribution
|
| TINV
| Returns the inverse of the Student's t-distribution
|
| TREND
| Returns values along a linear trend
|
| TRIMMEAN
| Returns the mean of the interior of a data set
|
| TTEST
| Returns the probability associated with a Student's t-test
|
| VAR
| Estimates variance based on a sample
|
| VARA
| Estimates variance based on a sample, including numbers, text, and logical values
|
| VARP
| Calculates variance based on the entire population
|
| VARPA
| Calculates variance based on the entire population, including numbers, text, and logical values
|
| WEIBULL
| Returns the Weibull distribution
|
| ZTEST
| Returns the one-tailed probability-value of a z-test |