Excel 2016 Formulas

Appendix A Excel Function Reference

This appendix contains a complete listing of the Excel worksheet functions. The functions are arranged alphabetically in tables by categories used by the Insert Function dialog box.

For more information about a particular function, including its arguments, select the function in the Insert Function dialog box and click Help on This Function.

On the Web

An interactive workbook that contains this information is available at this book’s website. The filename is worksheet functions.xlsx.

Table A.1 Compatibility Category Functions

Function	What It Does
BETADIST	Returns the cumulative beta probability density function.
BETAINV	Returns the inverse of the cumulative beta probability density function.
BINOMDIST	Returns the individual term binomial distribution probability.
CEILING	Rounds a number to the nearest integer or to the nearest multiple of significance.
CHIDIST	Returns the right-tailed probability of the chi-squared distribution.
CHIINV	Returns the inverse of the right-tailed probability of the chi-squared distribution.
CHITEST	Returns the test for independence.
CONFIDENCE	Returns the confidence interval for a population mean.
COVAR	Returns covariance, the average of the products of paired deviations.
CRITBINOM	Returns the smallest value for which the cumulative binomial distribution is ...