ACOS Function

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.

Radian Example

Syntax:

=ACOS(.85)

Result: 0.554811033 Radians

=ACOS (-.65)

Result: 2.278380764 Radian

Radian to Degrees

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.

Radian to Excel Formula

Start the discussion on Excelbuddy's Discourse

Scroll to Top
Send this to a friend