ACOS Function

Originally published at: ACOS Function in Excel - Excelbuddy.com

The ACOS Function returns the inverse cosine of a number in radians. The number must be between -1 and 1.

If the number is outside -1 to 1, Excel will return a #NUM error.

Syntax:

=acos(number)

Arguments:

  • number – Number between -1 and 1.

PV Function Usage Example:

Below is an example of how to use the ACOS Function. In the below example, we are looking for the inverse cosine of .85 and -.65. The result in radians in shown below.

A Radian is a unit of angle, equal to an angle at the center of a circle whose arc is equal in length to the radius. Please see the slide below.

Syntax:

=ACOS(.85)

Result: 0.554811033 Radians

=ACOS (-.65)

Result: 2.278380764 Radian

Radian to Degrees

Syntax:

=DEGREES(ACOS(-0.65))

=ACOS(-0.65)*180/PI()

You can easily convert the returned Radian from the ACOS function to degrees by using the DEGREES function and PI function as shown below.