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