Microsoft Office Tutorials and References

In Depth Information

**APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE**

AMORLINC(cost,date_purchased,ﬁ rst_period,salvage,period,rate,basis)

[Category: Financial]*

Returns the depreciation for each accounting period. This function is provided

for the French accounting system. If an asset is purchased in the middle of the

accounting period, the prorated depreciation is taken into account.

AND(logical1,logical2, ...) [Category: Logical]

Returns TRUE if all its arguments are TRUE; returns FALSE if one or more

arguments is FALSE. Guru Tip: Use the AND function as the ﬁ rst argument in an

IF function. To pay a $1000 bonus only when cell F2 is greater than 20000 and

cell H2 is greater than 45%, use =IF(AND(F2>20000,H2>0.45),1000,0).

AREAS(reference) [Category: Lookup & Reference]

Returns the number of areas in a reference. An area is a range of contiguous

cells or a single cell.

ASC(text) [Category: Text]

Changes full-width (double-byte) English letters or katakana within a character

string to half-width (single-byte) characters.

ASIN(number) [Category: Math]

Returns the arcsine of a number. The arcsine is the angle whose sine is number.

The returned angle is given in radians in the range -pi/2 to pi/2.

ASINH(number) [Category: Math]

Returns the inverse hyperbolic sine of a number. The inverse hyperbolic sine is

the value whose hyperbolic sine is number, so ASINH(SINH(number)) equals

number.

ATAN(number) [Category: Math]

Returns the arctangent of a number. The arctangent is the angle whose tangent

is number. The returned angle is given in radians in the range -pi/2 to pi/2.

ATAN2(x_num,y_num) [Category: Math]

Returns the arctangent of the speciﬁ ed x- and y-coordinates. The arctangent is

the angle from the x-axis to a line containing the origin (0, 0) and a point with

coordinates (x_num, y_num). The angle is given in radians between -pi and pi,

excluding -pi.

ATANH(number) [Category: Math]

Returns the inverse hyperbolic tangent of a number. Number must be between

-1 and 1 (excluding -1 and 1). The inverse hyperbolic tangent is the value whose

hyperbolic tangent is number, so ATANH(TANH(number)) equals number.

AVEDEV(number1,number2, ...) [Category: Statistical]]

Returns the average of the absolute deviations of data points from their mean.

AVEDEV is a measure of the variability in a data set.