Excel 2016 Bible

Appendix AWorksheet Function Reference

This appendix contains a complete list of Excel worksheet functions. The functions are arranged alphabetically by the categories displayed in 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 then click Help on This Function.

For newer functions, the Excel version in which they first appeared is indicated. Knowing when a function first became available is useful if you share your workbooks with people who use an earlier version of Excel.

An interactive workbook that contains this information is available on this book's website at www.wiley.com/go/excel2016bible. 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 one-tailed probability of the chi-squared distribution
CHIINV	Returns the inverse of the one-tailed probability of the chi-squared distribution
CHITEST	Returns the test for independence
CONFIDENCE	Returns the confidence ...