Home › Excel formulas › Compatibility functions
Excel Compatibility Functions: Full List with Examples
These are all the Excel Compatibility functions on Cellgrids. Open any function for its syntax, arguments, a worked example and a free practice spreadsheet.
| Function | What it does |
|---|---|
| BETADIST | Legacy version of the beta distribution — kept for compatibility with older files. |
| BINOMDIST | Legacy version of the binomial distribution — kept for compatibility with older files. |
| CHIDIST | Legacy version of the chi-squared distribution — kept for compatibility with older files. |
| CHIINV | Legacy inverse chi-squared distribution — kept for compatibility with older files. |
| CHITEST | Legacy chi-squared test — kept for compatibility with older files. |
| CONFIDENCE | Legacy confidence interval formula — kept for compatibility with older files. |
| COVAR | Legacy covariance formula — kept for compatibility with older files. |
| CRITBINOM | Legacy binomial criterion formula — kept for compatibility with older files. |
| EXPONDIST | Legacy exponential distribution — kept for compatibility with older files. |
| FDIST | Legacy F distribution — kept for compatibility with older files. |
| FINV | Legacy inverse F distribution — kept for compatibility with older files. |
| FTEST | Legacy F-test — kept for compatibility with older files. |
| GAMMADIST | Legacy gamma distribution — kept for compatibility with older files. |
| GAMMAINV | Legacy inverse gamma distribution — kept for compatibility with older files. |
| HYPGEOMDIST | Legacy hypergeometric distribution — kept for compatibility with older files. |
| LOGINV | Legacy inverse lognormal distribution — kept for compatibility with older files. |
| LOGNORMDIST | Legacy lognormal distribution — kept for compatibility with older files. |
| NEGBINOMDIST | Legacy negative binomial distribution — kept for compatibility with older files. |
| NORMDIST | Legacy normal distribution — kept for compatibility with older files. |
| NORMINV | Legacy inverse normal distribution — kept for compatibility with older files. |
| NORMSDIST | Legacy standard normal distribution — kept for compatibility with older files. |
| NORMSINV | Legacy inverse standard normal distribution — kept for compatibility with older files. |
| PERCENTRANK | Legacy percentage rank formula — kept for compatibility with older files. |
| POISSON | Legacy Poisson distribution — kept for compatibility with older files. |
| TDIST | Legacy Student's t-distribution — kept for compatibility with older files. |
| TINV | Legacy inverse t-distribution — kept for compatibility with older files. |
| WEIBULL | Legacy Weibull distribution — kept for compatibility with older files. |
| ZTEST | Legacy z-test formula — kept for compatibility with older files. |
Practice Compatibility functions free
Type formulas in a real spreadsheet and get instant feedback.
Start practice → Formulas cheat sheetFrequently asked questions
What are the main Excel Compatibility functions?
Cellgrids lists 28 Excel Compatibility functions. Popular ones include BETADIST, BINOMDIST, CHIDIST, CHIINV, CHITEST. Each has its own page with syntax, arguments and an example.
How can I practice Excel Compatibility functions online?
Open the free live spreadsheet on Cellgrids, type the function in a cell and check your answer. No Excel install or sign-up is needed to start.
Which Excel Compatibility function should a beginner learn first?
Start with BETADIST. Legacy version of the beta distribution — kept for compatibility with older files.