Microsoft Office Tutorials and References
In Depth Information
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE
ALPHABETICAL FUNCTION REFERENCE
While you’ve seen function references before, this one is different in a couple
of ways. First, it is alphabetical, so you don’t have to ﬁ gure out if AVERAGE is
considered to be in the math category or the statistics category. Second, I’ve
added guru tips on about a third of the functions. These will often give ideas of
how you can use the function.
ABS(number) [Category: Math]
Returns the absolute value of a number. The absolute value of a number is the
number without its sign.
Returns the accrued interest for a security that pays periodic interest.
ACCRINTM(issue,maturity,rate,par,basis) [Category: Financial]*
Returns the accrued interest for a security that pays interest at maturity.
ACOS(number) [Category: Math]
Returns the arccosine of a number. The arccosine is the angle whose cosine is
number. The returned angle is given in radians in the range 0 (zero) to pi.
ACOSH(number) [Category: Math]
Returns the inverse hyperbolic cosine of a number. Number must be greater
than or equal to 1. The inverse hyperbolic cosine is the value whose hyperbolic
cosine is number, so ACOSH(COSH(number)) equals number.
Lookup & Reference]
Creates a cell address as text, given speciﬁ ed row and column numbers. Guru
Tip: Use when you need to generate a cell address for use with INDIRECT,
as shown on page 32. In Excel 2007, use =ADDRESS(2^20,2^14) to return
$XFD$1048576. Also see page 32.
AMORDEGRC(cost,date_purchased,ﬁ rst_period, salvage, period, rate,
basis) [Category: Financial]*
Returns the depreciation for each accounting period. This function is provide
for the French accounting system. If an asset is purchased in the middle of the
accounting period, the prorated depreciation is taken into account. The function
is similar to AMORLINC, except that a depreciation coefﬁ cient is applied in the
calculation depending on the life of the assets.