Home MMForExcel Add-in Basic modeling

Dimensions

Operations on dimensions

Sort By

Newest
Most likes
Most views

MM_AVERAGEIF function

Description Equivalent of AVERAGEIF Excel function. Returns the average of values of all dimensions or specified dimensions of a range...

November 18th, 2021 557 views 0 likes
MM_SORTDIM

Description MM_SORTDIM enables us to sort the numerical values of the dimension of the target cell. This function is similar...

November 18th, 2021 490 views 1 likes
MM_AVERAGEIFS function

Description Returns the average of values of all dimensions or specified dimensions of a range that meet a chosen set...

November 18th, 2021 399 views 0 likes
MM_COUNTIF function

Description The equivalent of COUNTIF Excel function. Returns the number of dimension indexes of a range that meet a chosen...

November 18th, 2021 480 views 0 likes
MM_COUNTIFS function

Description The equivalent of COUNTIFS Excel function. Returns the number of dimension indexes of a range that meet a chosen...

November 18th, 2021 455 views 0 likes
MM_DIMINDEX function

Description Returns the index of the selected dimension of a specified loop or of the selected simulation. Syntax =MM_DIMINDEX("Name") "Name"...

November 18th, 2021 586 views 0 likes
MM_DIMSIZE function

Description Returns the size of a specified loop (number of dimensions) or the total number of launched simulations. Syntax =MM_DIMSIZE("Name")...

November 18th, 2021 255 views 0 likes
MM_FLATTENDIM function

Description Flattens dimensions of target range into one single table. You can chose to return either all indexes of all...

November 18th, 2021 475 views 0 likes
MM_MATCH function

Description Searches for a specified item in the dimensions of a cell and returns the index of the dimension where...

November 18th, 2021 273 views 0 likes
MM_RANK function

Description Returns the rank of the sorted values of the dimensions of a specified cell. Syntax =MM_RANK(Cell, SortingOrder, [Name, Index],...

November 18th, 2021 430 views 0 likes
MM_RESULT function

Description Returns the value of a multidimensional cell for specified loop dimensions. Sums dimensions for unspecified loops. Syntax =MM_RESULT(Cell, ["Name",...

November 18th, 2021 1300 views 1 likes
MM_RM function

Description Returns the value of a specified risk measure evaluated for a given multidimensional cell. You can specify which loop...

November 18th, 2021 372 views 2 likes
MM_SUM function

Description Sums the results of all simulations for a given cell. Syntax =MM_SUM(Cell) Cell Cell whose results of simulations you...

November 18th, 2021 486 views 0 likes
MM_SUMIF function

Description The equivalent of SUMIF Excel function. Returns the sum of values of all dimensions or specified dimensions of a...

November 18th, 2021 613 views 0 likes
MM_SUMIFS function

Description Equivalent of SUMIFS Excel function. Returns the sum of values of all dimensions or specified dimensions of a range...

November 18th, 2021 695 views 0 likes
MM_FILTERDIM function

Description Filters a grid taking into account values through all dimensions. Similar to MM_FILTER, except that dimensions from the input...

September 12th, 2023 322 views 0 likes