Excel® 2007 Bible

Appendix A. Worksheet Function Reference

This appendix contains a complete listing of Excel’s 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 click Help On This Function.

On the CD-ROM

A workbook that contains this information is available on the companion CD-ROM. The filename is worksheet functions.xlsx.

Table A.1. Cube Category Functions

Function	What It Does
CUBEKPIMEMBER[*]	Returns a key performance indicator name, property, and measure, and displays the name and property in the cell.
CUBEMEMBER[*]	Returns a member or tuple in a cube hierarchy.
CUBEMEMBERPROPERTY[*]	Returns the value of a member property in the cube.
CUBERANKEDMEMBER[*]	Returns the nth, or ranked, member in a set.
CUBESET[*]	Defines a calculated set of members or tuples by sending a set expression to the cube on the server.
CUBESETCOUNT[*]	Returns the number of items in a set.
CUBEVALUE[*]	Returns an aggregated value from a cube.
[*] Indicates a new function in Excel 2007.

Table A.2. Database Category Functions

Function	What It Does
DAVERAGE	Averages the values in a column of a list or database that match conditions you specify.
DCOUNT	Counts the cells that contain numbers in a column of a list or database that match conditions you specify.
DCOUNTA	Counts the nonblank cells in a column of a list or database that match conditions ...