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