The ACOS function returns the arccosine (in radians) of a given number.
This function takes a single Number as input. It outputs another Number: the arccossin, in radians, of the given number.
ACOS(number) -> arccosine
number (required, type:
The arccosine, in radians, of the given number.
The following example returns the arccosine of 0.5. Note that the arccossine of one half is sixty degrees, or π/3 radians, but the ACOS function doesn't output an angle in degrees or in radians in terms of pi. Rather, it provides a numerical estimation of the angle in radians:
ACOS(0.5) -> 1.0471975511965979
To calculate the arctangent in degrees, the ACOS function must be used in tandem with the DEGREES function, such as in the following example. Note that the output is not exactly 60, but it is extremely close. This is the result of small rounding errors:
DEGREES(ACOS(0.5)) -> 60.00000000000001
ACOS can also be used in tandem with the PI function to provide insight into how the angle in radians relates to terms of pi, such as in the following example. Note again that, due to small rounding errors, the output is not a precise numerical estimation of 1/3:
ACOS(0.5)/PI() -> 0.33333333333333337