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 median value in a list or array 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 value that occurs most frequently in a list or array of numbers.
MODE.MULTThe array of most frequent or repetitive values.
MODE.SNGLThe value that occurs most frequently in a list or array of numbers.
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 median value in a list or array 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 value that occurs most frequently in a list or array of numbers.
MODE.MULT
The array of most frequent or repetitive values.
MODE.SNGL
The value that occurs most frequently in a list or array of numbers.
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.

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