O'Reilly logo

Excel® 2010 Bible by John Walkenbach

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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
FunctionWhat It Does
BETADISTReturns the cumulative beta probability density function.
BETAINVReturns the inverse of the cumulative beta probability density function.
BINOMDISTReturns the individual term binomial distribution probability.
CHIDISTReturns the one-tailed probability of the chi-squared distribution.
CHIINVReturns the inverse of the one-tailed probability of the chi-squared distribution.
CHITESTReturns the test for independence.
CONFIDENCEReturns the confidence interval for a population mean.
COVARReturns covariance, the average of the products of paired deviations.
CRITBINOMReturns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value.
EXPONDISTReturns the exponential distribution.
FDISTReturns the F probability distribution.
FINVReturns the inverse of the F probability distribution.
FTESTReturns the result of an F-Test.
GAMMADISTReturns the gamma distribution.
GAMMAINV ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required