Alphabetical - M

MATCHThe position of a value in a list, table or cell range.
MAXThe largest value in a list or array of numbers.
MAXAThe largest value in a list or array of numbers (including logical values and text).
MAXIFS(2016) The largest value in a list or array of numbers 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 text string which is a substring of a given string.
MINThe smallest value in a list or array of numbers.
MINAThe smallest value in a list or array of numbers (including logical values and text).
MINIFS(2016) The smallest value in a list or array of numbers that satisfies multiple conditions.
MINUTEThe minute as an integer given a date serial number.
MINVERSEThe inverse matrix of an array.
MIRRThe internal rate of return 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.MULT(2010) The array of most frequent or repetitive values.
MODE.SNGL(2010) The 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.
MATCH
The position of a value in a list, table or cell range.
MAX
The largest value in a list or array of numbers.
MAXA
The largest value in a list or array of numbers (including logical values and text).
MAXIFS
(2016) The largest value in a list or array of numbers 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 text string which is a substring of a given string.
MIN
The smallest value in a list or array of numbers.
MINA
The smallest value in a list or array of numbers (including logical values and text).
MINIFS
(2016) The smallest value in a list or array of numbers that satisfies multiple conditions.
MINUTE
The minute as an integer given a date serial number.
MINVERSE
The inverse matrix of an array.
MIRR
The internal rate of return 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
(2010) The array of most frequent or repetitive values.
MODE.SNGL
(2010) 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.

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