This is a complete alphabetical list of all the Functions in Excel with a description. To see the syntax and a more in-depth description, the function is a link to the Microsoft Excel site.
Download the complete list.
FUNCTION TYPE AND DESCRIPTION
ABS function Math and trigonometry: Returns the absolute value of a number
ACCRINT function Financial: Returns the accrued interest for a security that pays periodic interest
ACCRINTM function Financial: Returns the accrued interest for a security that pays interest at maturity
ACOS function Math and trigonometry: Returns the arccosine of a number
ACOSH function Math and trigonometry: Returns the inverse hyperbolic cosine of a number
ADDRESS function Lookup and reference: Returns a reference as text to a single cell in a worksheet
AMORDEGRC function Financial: Returns the depreciation for each accounting period by using a depreciation coefficient
AMORLINC function Financial: Returns the depreciation for each accounting period
AND function Logical: Returns TRUE if all of its arguments are TRUE
AREAS function Lookup and reference: Returns the number of areas in a reference
ASC function Text: Changes full-width (double-byte) English letters or katakana within a character string to half-width (single-byte) characters
ASIN function Math and trigonometry: Returns the arcsine of a number
ASINH function Math and trigonometry: Returns the inverse hyperbolic sine of a number
ATAN function Math and trigonometry: Returns the arctangent of a number
ATAN2 function Math and trigonometry Returns the arctangent from x- and ycoordinates
ATANH function Math and trigonometry: Returns the inverse hyperbolic tangent of a number
AVEDEV function Statistical: Returns the average of the absolute deviations of data points from their mean
AVERAGE function Statistical: Returns the average of its arguments
AVERAGEA function Statistical: Returns the average of its arguments, including numbers, text, and logical values
AVERAGEIF function Statistical: Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria
AVERAGEIFS function Statistical: Returns the average (arithmetic mean) of all cells that meet multiple criteria.
BAHTTEXT function Text: Converts a number to text, using the ß (baht) currency format
Size : | 150.64 Kb |
Downloads: | 8380 |
Created: | 2017-10-09 |
Warning: Trying to access array offset on false in /home/tutovnfz/public_html/amp/article-amp.php on line 263
Others related eBooks about Full list of Excel functions
The user-friendly, object-oriented programming language Python is quickly becoming the most popular introductory programming language for both students and instructors.
Download PDF course about C Programming, free document in 134 pages for beginners students.
Download free Microsoft SQL Server tutorial course in PDF, training file in 112 chapters and 286 pages. Free unaffiliated ebook created from Stack OverFlow contributor.
Download tutorial intituled Learning Perl Through Examples, it's a free training document under 72 pages by Yun Shen.
This book presents computer programming as a key method for solving mathematical problems. There are two versions of the book, one for MATLAB and one for Python. The book was inspired by the Springer book TCSE 6: A Primer on Scientific Programming with Python (by Langtangen), but the style is more