Microsoft Office Tutorials and References
In Depth Information
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE
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
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,
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.