Home › Excel formulas › Cube functions
Excel Cube Functions: Full List with Examples
These are all the Excel Cube functions on Cellgrids. Open any function for its syntax, arguments, a worked example and a free practice spreadsheet.
| Function | What it does |
|---|---|
| CUBEVALUE | Returns a value from a data cube connected to an external server. |
| CUBEMEMBER | Returns a member from a cube for verification within the cube. |
| CUBESET | Defines a set of members from a data cube. |
| CUBESETCOUNT | Returns the number of items in a cube set. |
| CUBERANKEDMEMBER | Returns the nth ranked member from a cube set. |
| CUBEKPIMEMBER | Returns a key performance indicator property from a cube. |
| CUBEMEMBERPROPERTY | Returns a property value of a cube member. |
Practice Cube functions free
Type formulas in a real spreadsheet and get instant feedback.
Start practice → Formulas cheat sheetFrequently asked questions
What are the main Excel Cube functions?
Cellgrids lists 7 Excel Cube functions. Popular ones include CUBEVALUE, CUBEMEMBER, CUBESET, CUBESETCOUNT, CUBERANKEDMEMBER. Each has its own page with syntax, arguments and an example.
How can I practice Excel Cube functions online?
Open the free live spreadsheet on Cellgrids, type the function in a cell and check your answer. No Excel install or sign-up is needed to start.
Which Excel Cube function should a beginner learn first?
Start with CUBEVALUE. Returns a value from a data cube connected to an external server.