ACOS()

Syntax. ACOS(number)

Definition. The arccosine is the angle whose cosine is number.

Arguments

  • number (required) The cosine of the angle; must be between –1 and 1

Background. Use the ACOS() function to calculate the adjacent angle based on the cosine (see Figure 16-2). The result is a radian measure and has to be converted into degrees with the DEGREES() function. Because each angle occurs two times in a full circle, the value range for an arccosine is restricted:

  • If the angle is calculated as a radian measure, the value range spans 0 to π (pi).

  • If the angle is calculated in degrees, the value range spans 0 to 180 degrees.

The arccosine is strictly monotonic decreasing. The values of the arccosine in a coordinate plane create the graph shown in ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.