# Excel Functions

Syntax and Description with examples

More results...

Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors
Filter by Categories

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