Comparisons of Microsoft Excel functions to those available in Anaplan.
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:

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. 
Disclaimer
We update Anapedia content regularly to provide the most uptodate instructions.