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

ABS	Math and trigonometry		Returns the absolute value of a number
ACCRINT	Financial		Returns the accrued interest for a security that pays periodic interest
ACCRINTM	Financial		Returns the accrued interest for a security that pays interest at maturity
ACOS	Math and trigonometry		Returns the arccosine of a number
ACOSH	Math and trigonometry		Returns the inverse hyperbolic cosine of a number
ACOT	Math and trigonometry		Returns the arccotangent of a number
ACOTH	Math and trigonometry		Returns the hyperbolic arccotangent of a number
ADDRESS	Lookup and reference		Returns a reference as text to a single cell in a worksheet
AGGREGATE	Math and trigonometry		Returns an aggregate in a list or database
AMORDEGRC	Financial		Returns the depreciation for each accounting period by using a depreciation coefficient
AMORLINC	Financial		Returns the depreciation for each accounting period
AND	Logical		Returns TRUE if all of its arguments are TRUE
ARABIC	Math and trigonometry		Converts a Roman number to Arabic, as a number
AREAS	Lookup and reference		Returns the number of areas in a reference
ASC	Text		Changes full-width (double-byte) English letters or katakana within a character string to half-width (single-byte) characters
ASIN	Math and trigonometry		Returns the arcsine of a number
ASINH	Math and trigonometry		Returns the inverse hyperbolic sine of a number
ATAN	Math and trigonometry		Returns the arctangent of a number
ATAN2	Math and trigonometry		Returns the arctangent from x- and y-coordinates
ATANH	Math and trigonometry		Returns the inverse hyperbolic tangent of a number