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

LCM	Math and trigonometry		Returns the least common multiple
LEFT – LEFTB	Text		Returns the leftmost characters from a text value
LEN – LENB	Text		Returns the number of characters in a text string
LINEST	Statistical		Returns the parameters of a linear trend
LN	Math and trigonometry		Returns the natural logarithm of a number
LOG	Math and trigonometry		Returns the logarithm of a number to a specified base
LOG10	Math and trigonometry		Returns the base-10 logarithm of a number
LOGEST	Statistical		Returns the parameters of an exponential trend
LOGINV	Compatibility		Returns the inverse of the lognormal cumulative distribution
LOGNORM.DIST	Statistical		Returns the cumulative lognormal distribution
LOGNORM.INV	Statistical		Returns the inverse of the lognormal cumulative distribution
LOGNORMDIST	Compatibility		Returns the cumulative lognormal distribution
LOOKUP	Lookup and reference		Looks up values in a vector or array
LOWER	Text		Converts text to lowercase
MATCH	Lookup and reference		Looks up values in a reference or array
MAX	Statistical		Returns the maximum value in a list of arguments
MAXA	Statistical		Returns the maximum value in a list of arguments, including numbers, text, and logical values
MAXIFS	Statistical		Returns the maximum value among cells specified by a given set of conditions or criteria
MDETERM	Math and trigonometry		Returns the matrix determinant of an array
MDURATION	Financial		Returns the Macauley modified duration for a security with an assumed par value of $100