O'Reilly logo

Excel 2016 Formulas by Richard Kusleika, Michael Alexander

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 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.

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 ...

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