Справочник Пользователя для Apple numbers

 Dictionary of Functions

 

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

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

ACOSH(number)

 number:  A number greater than or equal to 1.

  

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.

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.

ACOSH(10.0676619957778) returns 3.

ACOSH(COSH(5)) returns 5.