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, table or cell range.
MAXAThe largest value in a list, table or cell range (including logical values and text).
MAXIFS(2019) The largest value in a list, table or cell range 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, table or cell range.
MINAThe smallest value in a list, table or cell range (including logical values and text).
MINIFS(2019) The smallest value in a list, table or cell range 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 number of permutations for a given number of items (with duplicates).
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, table or cell range.
MAXA
The largest value in a list, table or cell range (including logical values and text).
MAXIFS
(2019) The largest value in a list, table or cell range 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, table or cell range.
MINA
The smallest value in a list, table or cell range (including logical values and text).
MINIFS
(2019) The smallest value in a list, table or cell range 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
(2013) The unit matrix or the specified dimension.

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