Excel functions
Every Excel function (476), organized by category. Arguments in [brackets] are optional.
Formula Explainer · Paste any formula and see it broken down step by step. Free.
Try itCube (7)
=CUBEKPIMEMBER(connection, kpi_name, kpi_property, [caption])Returns a key performance indicator (KPI) property and displays the KPI name in the cell. A KPI is a quantifiable measurement, such as monthly gross profit or quarterly employee turnover, that is used to monitor an organization's performance.
=CUBEMEMBER(connection, member_expression, [caption])Returns a member or tuple from the cube. Use to validate that the member or tuple exists in the cube.
=CUBEMEMBERPROPERTY(connection, member_expression, property)Returns the value of a member property from the cube. Use to validate that a member name exists within the cube and to return the specified property for this member.
=CUBERANKEDMEMBER(connection, set_expression, rank, [caption])Returns the nth, or ranked, member in a set. Use to return one or more elements in a set, such as the top sales performer or the top 10 students.
=CUBESET(connection, set_expression, [caption], [sort_order], [sort_by])Defines a calculated set of members or tuples by sending a set expression to the cube on the server, which creates the set, and then returns that set to Microsoft Excel.
=CUBESETCOUNT(set)Returns the number of items in a set.
=CUBEVALUE(connection, [member_expression1], [member_expression2], ...)Returns an aggregated value from the cube.