### 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.

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 […]

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 […]

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 […]

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, […]

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

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

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

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 […]

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