O'Reilly logo

Microsoft® Excel® 2010 Formulas & Functions Inside Out by Helmut Reinke Egbert Jeschke Sara Unverhau, Eckehard Pfeifer, Bodo Fienitz, and Jens Bock

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

CUBEMEMBER()

Syntax. CUBEMEMBER(connection,member_expression,caption)

Definition. This function returns a member (cell) from a cube. Use CUBEMEMBER() to validate that the member exists and to pass the member to other functions through a cell reference.

Arguments

  • connection (required) The text string name of the workbook connection to the cube, in quotation marks. When you are entering the connection, after you type the first quotation mark, existing context-sensitive data connections are displayed (see Figure 14-4).

    Context sensitivity helps you enter formulas.

    Figure 14-4. Context sensitivity helps you enter formulas.

  • member_expression (required) Defines the position of a member in the cube based ...

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