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