Sigma Squared
Lexington, KY, USA
614-973-9100
Follow on:
Linkedin-in Twitter Youtube

Excel Formulas

CUBEMEMBER

  • May 31, 2023
Definition: CUBEMEMBER is a function that returns a member or tuple from an OLAP cube. Syntax: =CUBEMEMBER(connection, member_expression) Situation: This formula is suitable when you need to retrieve...
Read More

CUBEMEMBERPROPERTY

  • May 31, 2023
Definition: CUBEMEMBERPROPERTY is a function that returns the value of a specified property for a member or tuple from an OLAP cube. Syntax: =CUBEMEMBERPROPERTY(connection, member_expression, property_name) Situation: This...
Read More

CUBERANKEDMEMBER

  • May 31, 2023
Definition: CUBERANKEDMEMBER is a function that returns the nth ranked member or tuple from an OLAP cube, based on a specified measure. Syntax: =CUBERANKEDMEMBER(connection, set_expression, rank, [measure_expression]) Situation:...
Read More

CUBESET

  • May 31, 2023
Definition: CUBESET is a function that returns a set or tuple from an OLAP cube. Syntax: =CUBESET(connection, set_expression) Situation: This formula is suitable when you need to retrieve...
Read More

CUBEVALUE

  • May 31, 2023
Definition: CUBEVALUE is a function that returns the value of a measure from an OLAP cube. Syntax: =CUBEVALUE(connection, [member_expression1], [member_expression2], ..., [member_expression_n], [measure_expression]) Situation: This formula is suitable...
Read More

CUMIPMT

  • May 31, 2023
Definition: CUMIPMT is a function that returns the cumulative interest paid on a loan between two periods. Syntax: =CUMIPMT(rate, nper, pv, start_period, end_period, type) Situation: This formula is...
Read More

CONVERT

  • May 31, 2023
Definition: CONVERT is a function that converts a number from one measurement system to another. Syntax: =CONVERT(number, from_unit, to_unit) Situation: This formula is suitable when you need to...
Read More

CUMPRINC

  • May 31, 2023
Definition: CUMPRINC is a function that returns the cumulative principal paid on a loan between two periods. Syntax: =CUMPRINC(rate, nper, pv, start_period, end_period, type) Situation: This formula is...
Read More

CORREL

  • May 31, 2023
Definition: CORREL is a function that returns the correlation coefficient between two sets of data. Syntax: =CORREL(array1, array2) Situation: This formula is suitable when you need to find...
Read More

DATE

  • May 31, 2023
Definition: DATE is a function that returns the serial number of a date. Syntax: =DATE(year, month, day) Situation: This formula is suitable when you need to convert a...
Read More