Leading the way in Microsoft Office Development
 Home|

Excel

|Word|PowerPoint|Consultancy|Feedback|Contact 
 Excel > Functions > M< Previous | Next > 

 ABCDEFGHIJKL

M

NOPQRSTUVWXYZ 
 
MATCHThe position of a value in an array or list.
MAXThe largest value in a list or array of numbers.
MAXAThe largest value in a list or array of numbers (including text and logical values).
MDETERMThe matrix determinant of an array.
MDURATION*The modified duration for a security that pays interest periodically.
MEDIANThe median of the numbers in a list or cell range.
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 text and logical values).
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 cash flows.
MMULTThe matrix product of two arrays.
MODThe remainder after division.
MODEThe number that occurs most frequently in a range.
MONTHThe month as in 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 of cell range.
 
 Note: * These are Analysis ToolPak functions in Excel 2003

 Copyright © 2010 Better Solutions Limited. All Rights Reserved.Top