O'Reilly logo

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

On the Web

An interactive workbook that contains this information is available on 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 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 ...

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