Alphabetical - M

MAKEARRAY(Microsoft 365) The array calculated by applying a LAMBDA function.
MAP(Microsoft 365) The array formed by applying a map using a LAMBDA function.
MATCHThe position of a value in a list, table or cell range.
MAXThe largest value in a list, range or array.
MAXAThe largest value in a list, range or array (including logical values and text).
MAXIFS(2019) The largest value in a list, range or array that satisfies multiple conditions.
MDETERMThe matrix determinant of an array.
MDURATIONThe modified duration for a security that pays interest periodically.
MEDIANThe number in the middle of a set of numbers.
MIDThe characters from the middle of a text string.
MINThe smallest value in a list, range or array.
MINAThe smallest value in a list, range or array (including logical values and text).
MINIFS(2019) The smallest value in a list, range or array that satisfies multiple conditions.
MINUTEThe minute as an integer given a date serial number.
MINVERSEThe inverse matrix of an array.
MIRRThe interest rate for a series of unequal cash flows at regular intervals (explicit reinvestment rate).
MMULTThe matrix product of two arrays.
MODThe remainder after division.
MODE(MODE.SNGL) The first number that appears the most often in a set.
MODE.MULTThe array of all the numbers that appears the most often in a set.
MODE.SNGLThe first number that appears the most often in a set.
MONTHThe month as an integer given a date serial number.
MROUNDThe number rounded to the desired multiple.
MULTINOMIALThe multinomial of a set of numbers in a list or cell range.
MUNIT(2013) The unit matrix or the specified dimension.
MAKEARRAY
(Microsoft 365) The array calculated by applying a LAMBDA function.
MAP
(Microsoft 365) The array formed by applying a map using a LAMBDA function.
MATCH
The position of a value in a list, table or cell range.
MAX
The largest value in a list, range or array.
MAXA
The largest value in a list, range or array (including logical values and text).
MAXIFS
(2019) The largest value in a list, range or array 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 value in a list, range or array.
MINA
The smallest value in a list, range or array (including logical values and text).
MINIFS
(2019) The smallest value in a list, range or array 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 multinomial of a set of numbers in a list or cell range.
MUNIT
(2013) The unit matrix or the specified dimension.

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top