Excel Functions

Excel functions are mathematical formulas that can be used to perform calculations or other actions on data in a worksheet.

Functions can be used to perform simple tasks, such as summing a column of numbers, or more complex tasks, such as calculating a mortgage payment.

Functions can be entered into a cell directly, or they can be used in conjunction with other formulas.

Search

MEDIAN	Statistical		Returns the median of the given numbers
MID – MIDB	Text		Returns a specific number of characters from a text string starting at the position you specify
MIN	Statistical		Returns the minimum value in a list of arguments
MINA	Statistical		Returns the smallest value in a list of arguments, including numbers, text, and logical values
MINIFS	Statistical		Returns the minimum value among cells specified by a given set of conditions or criteria.
MINUTE	Date and time		Converts a serial number to a minute
MINVERSE	Math and trigonometry		Returns the matrix inverse of an array
MIRR	Financial		Returns the internal rate of return where positive and negative cash flows are financed at different rates
MMULT	Math and trigonometry		Returns the matrix product of two arrays
MOD	Math and trigonometry		Returns the remainder from division
MODE	Compatibility		Returns the most common value in a data set
MODE.MULT	Statistical		Returns a vertical array of the most frequently occurring, or repetitive values in an array or range of data
MODE.SNGL	Statistical		Returns the most common value in a data set
MONTH	Date and time		Converts a serial number to a month
MROUND	Math and trigonometry		Returns a number rounded to the desired multiple
MULTINOMIAL	Math and trigonometry		Returns the multinomial of a set of numbers
MUNIT	Math and trigonometry		Returns the unit matrix or the specified dimension
N	Information		Returns a value converted to a number
NA	Information		Returns the error value #N/A
NEGBINOM.DIST	Statistical		Returns the negative binomial distribution