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

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

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