Comparisons of Microsoft Excel functions to those available in Anaplan.

Use the links below to navigate to pages containing other Microsoft Excel functions.

 Excel function Excel description Anaplan solution MATCH Searches for a value in an array and returns the relative position of that item. Use the LOOKUP function to look up an amount from a source module using one or more mappings. Each mapping matches a: List-formatted line item Time period-formatted item Property from the source with a dimension of the target line item. MAX Returns the largest value from the numbers provided. Use the MAX function or MAX aggregation function. MAXA Returns the largest value from the values provided (numbers, text, and logical values). Use the MAX function. MDETERM Returns the matrix determinant of an array. There is no equivalent Anaplan function, but can be built using a calculation. MDURATION Returns the modified Macaulay duration for a security with an assumed par value of \$100. Use the MDURATION formula. MEDIAN Returns the median of the numbers provided. There is no equivalent Anaplan function, but can be built using a calculation. MID Extracts a substring from a string starting at any position. Use the MID formula to extract a substring from a string starting at any character. MIN Returns the smallest value from the numbers provided. Use the MIN function or MIN aggregation function to return the minimum of selected line items. MINA Returns the smallest value from the values provided (numbers, text, and logical values). Use the MIN function or MIN aggregation function to return the minimum of selected line items. MINUTE Returns the minutes (a number from 0 to 59) from a time value. There is no equivalent Anaplan function, but can be built using a calculation. MINVERSE Returns the inverse matrix for a given matrix. There is no equivalent Anaplan function, but can be built using a calculation. MIRR Returns the modified internal rate of return for a series of cash flows. Use the IRR formula. MMULT Returns the matrix product of two arrays. There is no equivalent Anaplan function, but can be built using a calculation. MOD Returns the remainder after a number is divided by a divisor. Modulus: remainder after dividing a dividend by a divisor. MONTH Returns the month (a number from 1 to 12) given a date value. Use the MONTH formula to convert a date or a time period to a calendar month as a number.