Apple numbers User Manual
Chapter 12
Dictionary of Functions
201
Trigonometric Functions
The trigonometric functions take radians as arguments.
Numbers provides these trigonometric functions.
Returns 1 when the argument is positive, –1 when the argument is
negative, and 0 when it’s zero.
negative, and 0 when it’s zero.
SQRT (page 274)
Calculates the square root of a number.
Calculates the sum of a set of numbers.
Calculates the sum of a set of numbers that satisfy a specified
condition.
condition.
SUMPRODUCT (page 278)
Calculates the sum of the products of corresponding numbers in
two or more ranges.
two or more ranges.
Calculates the sum of the squares of a set of numbers.
Truncates a decimal number to a specified number of digits.
Function
Description
Function
Description
Calculates the inverse cosine (arccosine) in the range 0 to pi
radians.
radians.
Calculates the inverse hyperbolic cosine of a number.
Calculates the inverse sine (arcsine) in the range –pi/2 through pi/2
radians.
radians.
Calculates the hyperbolic arcsine (inverse hyperbolic sine).
Calculates the inverse tangent (arctangent) in the range –pi/2
through pi/2 radians.
through pi/2 radians.
Finds the angle, relative to the positive x-axis, of a line passing
through the origin and a specified point.
through the origin and a specified point.
Calculates the inverse hyperbolic tangent of a number.
Calculates the cosine of an angle expressed in radians.
Calculates the hyperbolic cosine of a number.
Converts radians to degrees.
Converts degrees to radians.
Calculates the sine of an angle expressed in radians.
Calculates the hyperbolic sine of a number.
Calculates the tangent of an angle expressed in radians.
Calculates the hyperbolic tangent of a number.