Excel Compatibility Formulas
Functions retained for compatibility with earlier versions of Excel. Replaced by new functions with improved accuracy.
41 formulas
2 Beginner
10 Intermediate
29 Advanced
BETADIST
Advanced
=BETADIST(x, alpha, beta, [A], [B])BETAINV
Advanced
=BETAINV(probability, alpha, beta, [A], [B])BINOMDIST
Advanced
=BINOMDIST(number_s, trials, probability_s, cumulative)CHIDIST
Advanced
=CHIDIST(x, deg_freedom)CHIINV
Advanced
=CHIINV(probability, deg_freedom)CHITEST
Advanced
=CHITEST(actual_range, expected_range)CONFIDENCE
Advanced
=CONFIDENCE(alpha, standard_dev, size)COVAR
Advanced
=COVAR(array1, array2)CRITBINOM
Advanced
=CRITBINOM(trials, probability_s, alpha)EXPONDIST
Advanced
=EXPONDIST(x, lambda, cumulative)FDIST
Advanced
=FDIST(x, deg_freedom1, deg_freedom2)FINV
Advanced
=FINV(probability, deg_freedom1, deg_freedom2)FTEST
Advanced
=FTEST(array1, array2)GAMMADIST
Advanced
=GAMMADIST(x, alpha, beta, cumulative)GAMMAINV
Advanced
=GAMMAINV(probability, alpha, beta)HYPGEOMDIST
Advanced
=HYPGEOMDIST(sample_s, number_sample, population_s, number_pop)LOGINV
Advanced
=LOGINV(probability, mean, standard_dev)LOGNORMDIST
Advanced
=LOGNORMDIST(x, mean, standard_dev)MODE
Intermediate
=MODE(number1, [number2], ...)NEGBINOMDIST
Advanced
=NEGBINOMDIST(number_f, number_s, probability_s)NORMDIST
Advanced
=NORMDIST(x, mean, standard_dev, cumulative)NORMINV
Advanced
=NORMINV(probability, mean, standard_dev)NORMSDIST
Advanced
=NORMSDIST(z)NORMSINV
Advanced
=NORMSINV(probability)PERCENTILE
Intermediate
=PERCENTILE(array, k)PERCENTRANK
Intermediate
=PERCENTRANK(array, x, [significance])POISSON
Advanced
=POISSON(x, mean, cumulative)QUARTILE
Intermediate
=QUARTILE(array, quart)RANK
Beginner
=RANK(number, ref, [order])STDEV
Intermediate
=STDEV(number1, [number2], ...)STDEVP
Intermediate
=STDEVP(number1, [number2], ...)TDIST
Advanced
=TDIST(x, deg_freedom, tails)TINV
Advanced
=TINV(probability, deg_freedom)TTEST
Advanced
=TTEST(array1, array2, tails, type)VAR
Intermediate
=VAR(number1, [number2], ...)VARP
Intermediate
=VARP(number1, [number2], ...)WEIBULL
Advanced
=WEIBULL(x, alpha, beta, cumulative)ZTEST
Advanced
=ZTEST(array, x, [sigma])CONCATENATE
Beginner
=CONCATENATE(text1, [text2], ...)FLOOR
Intermediate
=FLOOR(number, significance)FORECAST
Intermediate
=FORECAST(x, known_y's, known_x's)