CUBEMEMBERPROPERTY function - Microsoft Support
The CUBEMEMBERPROPERTY function, one of the Cube functions in Excel, returns the value of a member property from a cube. Use it to validate that a member name exists within the cube, and to return the specified property for this member. CUBEMEMBERPROPERTY (connection, member_expression, property)
CUBEMEMBER function - Microsoft Support
This article describes the formula syntax and usage of the CUBEMEMBER function in Microsoft Excel. Returns a member or tuple from the cube. Use to validate that the member or tuple exists in the cube. CUBEMEMBER (connection, member_expression, [caption]) The CUBEMEMBER function syntax has the following arguments: Connection Required.
Cube functions (reference) - Microsoft Support
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. Returns the number of items in a set. Returns an aggregated value from the cube. Lists all Cube functions, such as CUBEMEMBER, CUBEKPIMEMBER, and CUBEVALUE functions.
IF function - Microsoft Support
How to use the IF function in Excel to make logical comparisons between data values.
Track your health and fitness goals in Excel - Microsoft Support
Just enter your age, height, weight, gender, activity level, and goal weight to calculate a daily calorie intake that's realistic and easy to achieve. > Calorie amortization schedule. Plan your fitness training program and log your workouts with this accessible template. Use the separate tabs to plan your exercise categories, weights, and reps.
Enable or disable macros in Microsoft 365 files
In Excel this option is Enable VBA macros (not recommended, potentially dangerous code can run) and it only applies to VBA macros. Excel also has a checkbox for Enable Excel 4.0 macros when VBA macros are enabled.
Use conditional formatting to highlight information in Excel
Conditional formatting can help make patterns and trends in your data more apparent. To use it, you create rules that determine the format of cells based on their values, such as the following monthly temperature data with cell colors tied to cell values.