O'Reilly logo

Excel® 2007 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 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 you ...

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