Excel compatibility functions
Compatibility functions in Excel, explained with live examples.
40 compatibility functions in Excel — 2 documented in depth so far, the rest indexed below and landing every week.
Documented compatibility functions
Syntax, examples, and the equivalent — ready now.
All Excel compatibility functions
The full set — deep dives on the way.
- 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
- CEILING
- Rounds a number to the nearest integer or to the nearest multiple of significance
- 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
- 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
- EXPONDIST
- Returns the exponential distribution
- FDIST
- Returns the F probability distribution
- FINV
- Returns the inverse of the F probability distribution
- FTEST
- Returns the result of an F-test
- GAMMADIST
- Returns the gamma distribution
- GAMMAINV
- Returns the inverse of the gamma cumulative distribution
- HYPGEOMDIST
- Returns the hypergeometric distribution
- LOGINV
- Returns the inverse of the lognormal cumulative distribution
- LOGNORMDIST
- Returns the cumulative lognormal distribution
- MODE
- Returns the most common value in a data set
- NEGBINOMDIST
- Returns the negative binomial distribution
- NORM.INV
- Returns the inverse of the normal cumulative distribution
- NORMDIST
- Returns the normal cumulative distribution
- NORMSDIST
- Returns the standard normal cumulative distribution
- NORMSINV
- Returns the inverse of the standard normal cumulative distribution
- PERCENTILE
- Returns the k-th percentile of values in a range
- PERCENTRANK
- Returns the percentage rank of a value in a data set
- POISSON
- Returns the Poisson distribution
- QUARTILE
- Returns the quartile of a data set
- STDEV
- Estimates standard deviation based on a sample
- STDEVP
- Calculates standard deviation based on the entire population
- TDIST
- Returns the Student's t-distribution
- TINV
- Returns the inverse of the Student's t-distribution
- TTEST
- Returns the probability associated with a Student's t-test
- VAR
- Estimates variance based on a sample
- VARP
- Calculates variance based on the entire population
- WEIBULL
- Calculates variance based on the entire population, including numbers, text, and logical values
- ZTEST
- Returns the one-tailed probability-value of a z-test
More Excel function categories