Advanced Excel - Compatibility Functions

In Excel 2010 or later, the functions listed in this category were replaced with new functions that provide improved accuracy and have names that reflect their usage better. The new functions can be found in Statistical functions and Math and trigonometry functions. If backward compatibility is not required, you should start using the new functions.

You can still use these earlier versions of functions for compatibility with earlier versions of Excel. If you are using Excel 2007, you will find these functions in the Statistical or Math & Trig categories on the Formulas tab.

Compatibility Functions

The following table lists all the Compatibility functions −

S.No.	Function and Description
1	BETADIST Returns the cumulative beta probability density function
2	BETAINV Returns the inverse of the cumulative beta probability density function
3	BINOMDIST Returns the individual term binomial distribution probability
4	CEILING Rounds a number to the nearest integer or to the nearest multiple of significance
5	CHIDIST Returns the one-tailed probability of the chi-squared distribution
6	CHIINV Returns the inverse of the one-tailed probability of the chi-squared distribution
7	CHITEST Returns the test for independence
8	CONFIDENCE Returns the confidence interval for a population mean
9	COVAR Returns covariance, the average of the products of paired deviations
10	CRITBINOM Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value
11	EXPONDIST Returns the exponential distribution
12	FDIST Returns the F probability distribution
13	FINV Returns the inverse of the F probability distribution
14	FLOOR Rounds a number down, toward 0
15	FTEST Returns the result of an F-Test
16	GAMMADIST Returns the gamma distribution
17	GAMMAINV Returns the inverse of the gamma cumulative distribution
18	HYPGEOMDIST Returns the hypergeometric distribution
19	LOGINV Returns the inverse of the lognormal distribution
20	LOGNORMDIST Returns the cumulative lognormal distribution
21	MODE Returns the most common value in a data set
22	NEGBINOMDIST Returns the negative binomial distribution
23	NORMDIST Returns the normal cumulative distribution
24	NORMINV Returns the inverse of the normal cumulative distribution
25	NORMSDIST Returns the standard normal cumulative distribution
26	NORMSINV Returns the inverse of the standard normal cumulative distribution
27	PERCENTILE Returns the kth percentile of values in a range
28	PERCENTRANK Returns the percentage rank of a value in a data set
29	POISSON Returns the Poisson distribution
30	QUARTILE Returns the quartile of a data set
31	RANK Returns the rank of a number in a list of numbers
32	STDEV Estimates standard deviation based on a sample, ignoring text and logical values
33	STDEVP Calculates standard deviation based on the entire population, ignoring text and logical values
34	TDIST Returns the student’s t-distribution
35	TINV Returns the inverse of the student’s t-distribution
36	TTEST Returns the probability associated with a student’s t-Test
37	VAR Estimates variance based on a sample, ignoring logical values and text
38	VARP Calculates variance based on the entire population, ignoring logical values and text
39	WEIBULL Returns the Weibull distribution
40	ZTEST Returns the two-tailed P-value of a z-test