Microsoft Office Tutorials and References

In Depth Information

**APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE**

APPENDIX 1

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.

ACCRINT(issue,ﬁ rst_interest,settlement,rate,par,frequency,basis)

[Category: Financial]*

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.

ADDRESS(row_num,column_num,abs_num,a1,sheet_text) [Category:

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.

167