Excel Function Reference

Functions alphabetically | Functions by category

Functions are sorted from A to Z, click on a letter to quickly navigate in the table below.

Click on a link to get more detailed information about a function.

Function name Description Category
ABS function Converts negative numbers to positive numbers. Math and trigonometry
ACCRINT function Calculates the accrued interest for a security that pays periodic interest. Financial
ACCRINTM function Calculates the accrued interest for a security that pays interest at maturity. Financial
ACOS function Calculates the arccosine, or inverse cosine, of a number. Math and trigonometry
ACOSH function Calculates the inverse hyperbolic cosine of a number. Math and trigonometry
ACOT function Calculates the inverse cotangent of a number. Math and trigonometry
ACOTH function Calculates the inverse hyperbolic cotangent of a number. Math and trigonometry
ADDRESS function Returns the address of a specific cell, you need to provide a row and column number. Lookup and reference
AGGREGATE function Perform different specific functions to a list or database. Math and trigonometry
AMORDEGRC function Calculates the depreciation for each accounting period. This function is designed for the French accounting system. Financial
AMORLINC function Calculates the depreciation for each accounting period. Financial
AND function Perform a logical test in each argument and if all arguments return TRUE the AND function returns TRUE. Logical
AREAS function Returns the number of cell ranges and single cells in a reference. Lookup and reference
ASC function Converts full-width (double-byte) characters to half-width (single-byte) characters. Text
ASIN function Calculates the arcsine of a number. Math and trigonometry
ASINH function Calculates the inverse hyperbolic sine of a number. Math and trigonometry
ATAN function Calculates the arctangent of a number. Math and trigonometry
ATAN2 function Calculates the arctangent of an angle using specific x- and y-coordinates. Math and trigonometry
ATANH function Calculates the inverse hyperbolic tangent of a number. Math and trigonometry
AVEDEV function Calculates the average of the absolute deviations of data points from their mean. Statistical
AVERAGE function Calculates the average of numbers in a cell range. Statistical
AVERAGEA function Returns the average of a group of values. Text and boolean value FALSE evaluates to 0. TRUE to 1. Statistical
AVERAGEIF function Returns the average of cell values that are valid for a given condition. Statistical
AVERAGEIFS function Returns the average of cell values that evaluates to TRUE for multiple criteria. Statistical
BASE function Converts a number into a text representation with a given radix (base). Math and trigonometry
BETA.DIST function Calculates the beta distribution. Statistical
BETA.INV function Calculates the inverse of the cumulative beta distribution. Statistical
BETADIST function Calculates the beta distribution, it represents outcomes in the form of probabilities. Compatibility
BETAINV function Calculates the inverse of the beta distribution. Compatibility
BIN2DEC function Converts a binary number to the decimal number system. Engineering

Back to top



Popular Pages

More Info