© 2010 CustomGuide, Inc.
Engineering and Cube
These last functions are also possibly the functions that
will be used the least. .
This table lists some of the Engineering Functions
available in Excel 2010.
Table 7-14: Overview of Engineering Functions
Returns the modified Bessel function In(x).
Converts a binary number to decimal.
Converts real and imaginary coefficients into a
Converts a number from one measurement system to
Tests whether two numbers are equal.
This table lists some of the Cube Functions available in
Table 7-15: Overview of Cube Functions
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.
Returns the logical value FALSE
Returns a member
or tuple from the cube. Use to validate that the
member or tuple exists in the cube.
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.
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.
[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
Returns the number of items in a set.
Returns an aggregated value from the cube.
Exercise File: None required.
Become familiar with some of Excel’s
Engineering and Cube functions.
More Functions and Formulas