# Excel Functions

Syntax and Description with examples

Generic filters
Filter by Categories
Free Excel Macro
 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