Appendix 1: 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.

on_the_web.eps

An interactive workbook that contains this information is available at 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 products of paired deviations.

CRITBINOM

Returns the smallest value for which the cumulative binomial distribution is ...

Get Excel 2013 Formulas now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.