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. |
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. |
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