Excel® 2010 Bible

Appendix A. Worksheet Function Reference

This appendix contains a complete listing 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.

NOTE

An interactive workbook that contains this information is available on the companion CD-ROM. 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.
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 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 less than or equal to a criterion value.
EXPONDIST	Returns the exponential distribution.
FDIST	Returns the F probability distribution.
FINV	Returns the inverse of the F probability distribution.
FTEST	Returns the result of an F-Test.
GAMMADIST	Returns the gamma distribution.
GAMMAINV ...