Trigonometric functions
These functions operate on numbers and require numeric expressions as arguments. All trigonometric functions use radians as the unit of measurement. Once you have obtained a result, you can convert the radians into degrees using the DEGREES function.
Calculates the arc cosine (the inverse of cosine) and returns the corresponding angle in radians, in the range 0 to pi. Format: =ACOS(number) Argument: Example: =ACOS(5/7) calculates the arc cosine of 5/7 (cosine 0.7143) and returns 0.7752 (radians). Calculates the arc sine (the inverse of sine) and returns the corresponding angle in radians, in the range -pi/2 to pi/2. Format: =ASIN(number) Argument: Example: =ASIN(1) calculates that the arc sine of 1 is pi/2 radians (90 degrees), and returns 1.570 (radians). Calculates the arc tangent (the inverse of tangent) and returns the corresponding angle in radians, in the range -pi/2 to pi/2. Format: =ATAN(number) Argument: Example: =ATAN(1) calculates that the arc tangent of 1 is pi/4 (45 degrees), and returns .785 (radians). Calculates the angle between the positive x-axis and a line that starts at the origin (0,0) and passes through the x and y coordinates you specify, and returns the angle in radians, in the range -pi to pi. Format: =ATAN2(x number,y number) Arguments: Example: =ATAN2(1,1) determines that the angle between the positive x-axis and the line that passes through the coordinates (1,1) is 45 degrees, and returns .785 (radians). Calculates the cosine of a number, where the number is an angle in radians. Format: =COS(number) Argument: Example: =COS(1.0472) returns 0.5, the cosine of 1.0472 radians (60 degrees). Converts the number of radians to an angle in degrees. Format: =DEGREES(radians number) Argument: Example: =DEGREES(PI()) returns 180 (pi radians = 180 degrees). Converts the number of degrees to radians, the standard unit used for trigonometric functions. Format: =RADIANS(degrees number) Argument: Example: =RADIANS(90) returns 1.5708 (90 degrees = 1.5708 radians). Calculates the sine of a number, where the number is the angle in radians. Format: =SIN(number) Argument: Example: =SIN(radians(30)) returns 0.5, the sine of 30 degrees. Calculates the tangent of a number, where the number is the angle in radians. Format: =TAN(number) Argument: Example: =TAN(radians(45)) returns 1, the tangent of a 45-degree angle. Related topic
|
||||||||||||||||||||||||||||||
Table of contents | Index |