Compatibility functions

The functions in this category have been replaced with one or more new functions. Consider using the newer versions as they are better, the functions presented here are available for backward compatibility but may be removed in future Excel versions by Microsoft.

Old functions New functions
CONFIDENCE function CONFIDENCE.NORM function[2010]
CONFIDENCE.T function[2010]
FLOOR function FLOOR.MATH function[2013]
FLOOR.PRECISE function[2010]
MODE function MODE.MULT function[2010]
MODE.SNGL function[2010]
RANK function RANK.AVG function[2010]
RANK.EQ function[2010]
STDEV function STDEV.S function[2010]
BETADIST function BETA.DIST function[2010]
BINOMDIST function BINOM.DIST function[2010]
CHIDIST function CHISQ.DIST function[2010]
CHISQ.DIST.RT function[2010]
CHIINV function CHISQ.INV function[2010]
CHISQ.INV.RT function[2010]

How to use the PERCENTRANK function

The PERCENTRANK function calculates the percent rank of a given number compared to the whole data set. The image above […]

How to use the QUARTILE function

The QUARTILE function returns the quartile of a data set, use the QUARTILE function to divide data into groups. This […]

How to use the LOGNORMDIST function

The LOGNORMDIST function calculates the cumulative lognormal distribution of argument x, based on a normally distributed ln(x) with the arguments of […]

How to use the GAMMADIST function

The GAMMADIST function calculates the gamma often used in queuing analysis in probability statistics. This function is outdated and has […]

How to use the FTEST function

The FTEST function calculates the value from an F-test. The value shows if the variances from two data sets are […]

How to use the FORECAST function

The FORECAST function calculates a value based on existing x and y values using linear regression. Use this function to […]

How to use the FDIST function

The FDIST function calculates the F probability of the right-tailed distribution for two tests. This function is outdated and is […]

How to use the EXPONDIST function

The EXPONDIST function calculates the exponential distribution representing an outcome in the form of probability. This function is in the compatibility […]

How to use the CRITBINOM function

The CRITBINOM function calculates the minimum value for which the binomial distribution is equal to or greater than a given […]

How to use the CHITEST function

The CHITEST function calculates the test for independence, the value returned from the chi-squared statistical distribution and the correct degrees […]

How to use the COVAR function

The COVAR function calculates the covariance meaning the average of the products of deviations for each pair in two different […]

How to use the CHIINV function

The CHIINV function calculates the inverse probability of the chi-squared distribution. The CHIINV function is outdated and you will find […]

How to use the CHIDIST function

The CHIDIST function calculates the probability of the chi-squared distribution. Use this function to check if a hypothesize is valid. The […]

How to use the BINOMDIST function

The BINOMDIST function calculates the individual term binomial distribution probability, use this function when the success probability is constant through […]

How to use the BETAINV function

The BETAINV function calculates the inverse of the beta distribution. This function is outdated and replaced by the BETA.INV function […]

How to use the BETADIST function

The BETADIST function calculates the beta distribution representing an outcome in the form of probability. This function is in the compatibility […]

How to use the CONFIDENCE function

The CONFIDENCE function calculates the confidence interval for a population mean, using a normal distribution. Formula in cell B6: =CONFIDENCE(B3, […]

How to use the STDEV function

The STDEV function calculates the standard deviation of a group of values. The standard deviation shows how much the values […]

How to use the MODE function

The MODE function calculates the most frequent number in a cell range. Number 4 exists 3 times on picture above […]

How to use the RANK function

The RANK function calculates the rank of a specific number compared to a list of numbers. Formula in cell C3: […]

How to use the FLOOR function

The FLOOR function rounds a number down, toward zero, to the nearest multiple of significance. 1. FLOOR Function Syntax FLOOR(number, significance) […]

How to rank text uniquely without duplicates

Table of Contents How to rank text uniquely without duplicates How to rank uniquely based on a condition Get Excel […]

Find latest date in a list

The image above shows a formula in cell D3 that extracts the latest date in cell range B3:B15. =MAX(B3:B15) The MAX […]