Excel Functions

Syntax and Description with examples

Search now!
Generic filters
Filter by Categories
Free Excel Macro
Premium Excel Macro
Add ins
Templates
VBA Codes

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