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.
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
What It Does
Returns a key performance indicator name, property, and measure, and displays the name and property in the cell.
Returns a member or tuple in a cube hierarchy.
Returns the value of a member property in the cube.
Returns the nth, or ranked, member in a set.
Defines a calculated set of members or tuples by sending a set expression to the cube on the server.
Returns the number of items in a set.
Returns an aggregated value from a cube.
[*] Indicates a new function in Excel 2007.
Table A.2. Database Category Functions
What It Does
Averages the values in a column of a list or database that match conditions you specify.
Counts the cells that contain numbers in a column of a list or database that match conditions you specify.
Counts the nonblank cells in a column of a list or database that match conditions you ...