O'Reilly logo

Microsoft® Excel® 2010 Formulas & Functions Inside Out by Helmut Reinke Egbert Jeschke Sara Unverhau, Eckehard Pfeifer, Bodo Fienitz, and Jens Bock

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required