Appendix A. Excel Functions (in Alphabetical Order)

This appendix lists all of the functions in Microsoft Excel alphabetically.

Function

Excel Category

Description

ABS

Math & 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 & Trigonometry

Returns the arc cosine or the inverse cosine of a number

ACOSH

Math & Trigonometry

Returns the inverse hyperbolic cosine of a number

ADDRESS

Lookup & Reference

Returns a reference to a table cell as text

AGGREGATE (2010)

Math & Trigonometry

Returns an aggregate in a list or database

AMORDEGRC

Financial

Returns the depreciation amount to apply ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.