Alphabetical - M

MAKEARRAY	(2021) New. The array calculated by applying a LAMBDA function.
MAP	(2021) New. The array formed by applying a map using a LAMBDA function.
MATCH	(XMATCH) The position of a value in a list, table or cell range.
MAX	The largest numerical value.
MAXA	The largest numerical value (including logical values and text).
MAXIFS	(2019) New. The largest numerical value that satisfies multiple conditions.
MDETERM	The matrix determinant of an array.
MDURATION	The modified duration for a security that pays interest periodically.
MEDIAN	The number in the middle of a set of numbers.
MID	The characters from the middle of a text string.
MIN	The smallest numerical value.
MINA	The smallest numerical value (including logical values and text).
MINIFS	(2019) New. The smallest numerical value that satisfies multiple conditions.
MINUTE	The minute as an integer given a date serial number.
MINVERSE	The inverse matrix of an array.
MIRR	The interest rate for a series of unequal cash flows at regular intervals (explicit reinvestment rate).
MMULT	The matrix product of two arrays.
MOD	The remainder after division.
MODE	(MODE.SNGL) The first number that appears the most often in a set.
MODE.MULT	The array of all the numbers that appears the most often in a set.
MODE.SNGL	The first number that appears the most often in a set.
MONTH	The month as an integer given a date serial number.
MROUND	The number rounded to the desired multiple.
MULTINOMIAL	The number of permutations for a given number of items (with duplicates).
MUNIT	The unit matrix or the specified dimension.

MAKEARRAY (2021) New. The array calculated by applying a LAMBDA function.
MAP (2021) New. The array formed by applying a map using a LAMBDA function.
MATCH (XMATCH) The position of a value in a list, table or cell range.
MAX The largest numerical value.
MAXA The largest numerical value (including logical values and text).
MAXIFS (2019) New. The largest numerical value that satisfies multiple conditions.
MDETERM The matrix determinant of an array.
MDURATION The modified duration for a security that pays interest periodically.
MEDIAN The number in the middle of a set of numbers.
MID The characters from the middle of a text string.
MIN The smallest numerical value.
MINA The smallest numerical value (including logical values and text).
MINIFS (2019) New. The smallest numerical value that satisfies multiple conditions.
MINUTE The minute as an integer given a date serial number.
MINVERSE The inverse matrix of an array.
MIRR The interest rate for a series of unequal cash flows at regular intervals (explicit reinvestment rate).
MMULT The matrix product of two arrays.
MOD The remainder after division.
MODE (MODE.SNGL) The first number that appears the most often in a set.
MODE.MULT The array of all the numbers that appears the most often in a set.
MODE.SNGL The first number that appears the most often in a set.
MONTH The month as an integer given a date serial number.
MROUND The number rounded to the desired multiple.
MULTINOMIAL The number of permutations for a given number of items (with duplicates).
MUNIT The unit matrix or the specified dimension.