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 ...

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

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.