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.
MAXThe largest numerical value.
MAXAThe largest numerical value (including logical values and text).
MAXIFS(2019) New. The largest numerical value 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 numerical value.
MINAThe smallest numerical value (including logical values and text).
MINIFS(2019) New. The smallest numerical value 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).
MUNITThe 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.

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