| MATCH | The position of a value in an array or list. |
| MAX | The largest value in a list or array of numbers. |
| MAXA | The largest value in a list or array of numbers, including text and logical values. |
| MDETERM | The matrix determinant of an array. |
| MDURATION* | The modified duration for a security that pays interest periodically. |
| MEDIAN | The median of the numbers in a list or cell range. |
| MID | The text string which is a substring of a given string. |
| MIN | The smallest value in a list or array of numbers. |
| MINA | The smallest value in a list or array of numbers, including text and logical values. |
| MINUTE | The minute as an integer given a date serial number. |
| MINVERSE | The inverse matrix of an array. |
| MIRR | The internal rate of return for a series of cash flows. |
| MMULT | The matrix product of two arrays. |
| MOD | The remainder after division. |
| MODE | The number that occurs most frequently in a range. |
| MONTH | The month as in integer given a date serial number. |
| MROUND* | The number rounded to the desired multiple. |
| MULTINOMIAL* | The multinomial of a set of numbers in a list of cell range. |
