BETADIST
Returns the beta cumulative distribution function.
CompatibilityCompatibility / LegacyLegacy / Older Versions
Compatibility
Compatibility functions exist to support older Excel files and environments.
They ensure consistent behavior across Excel versions.
Modern alternatives are often available for new workbooks.
Tips
- Prefer modern functions for new files.
- Test shared workbooks across versions.
Excel functions in this category (40)
BETAINV
Returns the inverse of the cumulative distribution function for a specified beta distribution.
CompatibilityCompatibility / LegacyLegacy / Older Versions
BINOMDIST
Returns the individual term binomial distribution probability.
CompatibilityCompatibility / LegacyLegacy / Older Versions
CEILING
Rounds a number to the nearest integer or to the nearest multiple of significance.
CompatibilityCompatibility / LegacyLegacy / Older Versions
CHIDIST
Returns the one-tailed probability of the chi-squared distribution.
CompatibilityCompatibility / LegacyLegacy / Older Versions
CHIINV
Returns the inverse of the one-tailed probability of the chi-squared distribution.
CompatibilityCompatibility / LegacyLegacy / Older Versions
CHITEST
Returns the test for independence.
CompatibilityCompatibility / LegacyLegacy / Older Versions
CONFIDENCE
Returns the confidence interval for a population mean.
CompatibilityCompatibility / LegacyLegacy / Older Versions
COVAR
Returns covariance, the average of the products of paired deviations.
CompatibilityCompatibility / LegacyLegacy / Older Versions
CRITBINOM
Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value.
CompatibilityCompatibility / LegacyLegacy / Older Versions
EXPONDIST
Returns the exponential distribution.
CompatibilityCompatibility / LegacyLegacy / Older Versions
FDIST
Returns the F probability distribution.
CompatibilityCompatibility / LegacyLegacy / Older Versions
FINV
Returns the inverse of the F probability distribution.
CompatibilityCompatibility / LegacyLegacy / Older Versions
FLOOR
Rounds a number down, toward zero.
CompatibilityCompatibility / LegacyLegacy / Older Versions
FTEST
Returns the result of an F-test.
CompatibilityCompatibility / LegacyLegacy / Older Versions
GAMMADIST
Returns the gamma distribution.
CompatibilityCompatibility / LegacyLegacy / Older Versions
GAMMAINV
Returns the inverse of the gamma cumulative distribution.
CompatibilityCompatibility / LegacyLegacy / Older Versions
HYPGEOMDIST
Returns the hypergeometric distribution.
CompatibilityCompatibility / LegacyLegacy / Older Versions
LOGINV
Returns the inverse of the lognormal cumulative distribution.
CompatibilityCompatibility / LegacyLegacy / Older Versions
LOGNORMDIST
Returns the cumulative lognormal distribution.
CompatibilityCompatibility / LegacyLegacy / Older Versions
MODE
Returns the most common value in a data set.
CompatibilityCompatibility / LegacyLegacy / Older Versions
NEGBINOMDIST
Returns the negative binomial distribution.
CompatibilityCompatibility / LegacyLegacy / Older Versions
NORM.INV
Returns the inverse of the normal cumulative distribution.
CompatibilityCompatibility / LegacyLegacy / Older Versions
NORMDIST
Returns the normal cumulative distribution.
CompatibilityCompatibility / LegacyLegacy / Older Versions
NORMSDIST
Returns the standard normal cumulative distribution.
CompatibilityCompatibility / LegacyLegacy / Older Versions
NORMSINV
Returns the inverse of the standard normal cumulative distribution.
CompatibilityCompatibility / LegacyLegacy / Older Versions
PERCENTILE
Returns the k-th percentile of values in a range.
CompatibilityCompatibility / LegacyLegacy / Older Versions
PERCENTRANK
Returns the percentage rank of a value in a data set.
CompatibilityCompatibility / LegacyLegacy / Older Versions
POISSON
Returns the Poisson distribution.
CompatibilityCompatibility / LegacyLegacy / Older Versions
QUARTILE
Returns the quartile of a data set.
CompatibilityCompatibility / LegacyLegacy / Older Versions
RANK
Returns the rank of a number in a list of numbers.
CompatibilityCompatibility / LegacyLegacy / Older Versions
STDEV
Estimates standard deviation based on a sample.
CompatibilityCompatibility / LegacyLegacy / Older Versions
STDEVP
Calculates standard deviation based on the entire population.
CompatibilityCompatibility / LegacyLegacy / Older Versions
TDIST
Returns the Student's t-distribution.
CompatibilityCompatibility / LegacyLegacy / Older Versions
TINV
Returns the inverse of the Student's t-distribution.
CompatibilityCompatibility / LegacyLegacy / Older Versions
TTEST
Returns the probability associated with a Student's t-test.
CompatibilityCompatibility / LegacyLegacy / Older Versions
VAR
Estimates variance based on a sample.
CompatibilityCompatibility / LegacyLegacy / Older Versions
VARP
Calculates variance based on the entire population.
CompatibilityCompatibility / LegacyLegacy / Older Versions
WEIBULL
Calculates variance based on the entire population, including numbers, text, and logical values.
CompatibilityCompatibility / LegacyLegacy / Older Versions
ZTEST
Returns the one-tailed probability-value of a z-test.
CompatibilityCompatibility / LegacyLegacy / Older Versions