beautypg.com

Acosh, Address – Apple Numbers '08 User Manual

Page 207

background image

Chapter 12

Dictionary of Functions

207

Notes
To see the resulting angle in degrees instead of radians, use the DEGREES function.

ACOSH

The ACOSH function calculates the inverse hyperbolic cosine of a number.

ACOSH(number)

 number: A number greater than or equal to 1.

ADDRESS

The ADDRESS function constructs a cell address string from separate row, column, and
table identifiers.

ADDRESS(row, column, [type], [style], [table])

 row: The row number of the address.
 column: The column number of the address.
 type: Optional; a number specifying whether the row and column numbers are

relative or absolute:

1 or missing treats row and column as absolute references.

2 treats the row number as an absolute reference and the column number as a
relative reference.

3 treats the row number as a relative reference and the column number as an
absolute reference.

4 treats both row and column numbers as relative references.

 style: Optional; the address style:

TRUE, 1, or omitted formats the address using the A1 style, in which the letter
specifies the column and the number specifies the row.

FALSE formats the address using the R1C1 style, which isn’t supported and returns an
error.

Examples

ACOS(SQRT(2)/2) returns 0.785398163397448, which is approximately pi/4.

ACOS(0.54030230586814) returns 1.

DEGREES(ACOS(.5)) returns 60, the degree measure of an angle that has a cosine of 0.5.

Examples

ACOSH(10.0676619957778) returns 3.

ACOSH(COSH(5)) returns 5.