ExcelFunctions.net Logo

The Excel ACOS Function

Home » Excel-Built-In-Functions » Excel-Math-Functions » Excel-Acos-Function
Search this site:
Custom Search
Arccosine
The Arccosine is the inverse of the cosine.

Therefore, for the simple right-angled triangle below, the arccosine of the adjacent side, a, divided by the hypotenuse, h, is equal to the angle θ.
Right-Angled Triangle
i.e. for the triangle above,
Arccosine Equation
The Inverse trig. functions are discussed further on the Wikipedia Inverse Trigonometric Functions Page

Basic Description

The Excel ACOS function calculates the arccosine (ie. the inverse cosine) of a given number, and returns an angle, in radians, between 0 and π.

The format of the function is :

ACOS( Number )

Where the Number argument is the value, between -1 and +1, for which you want to calculate the arccosine.


Converting from Radians to Degrees
If you want the angle returned by the Acos function to be expressed in degrees, you can convert it, using the Excel Degrees function :
=DEGREES( Radians )
An example of this is included below.

Example

Column A of the spreadsheet below, shows examples of the Excel Acos Function, used to calculate the arccosine of different values. In the example in cell A4, the result is converted from radians, into degrees.

The formulas are shown in the spreadsheet on the left and the results are shown in the spreadsheet on the right.

 Formulas
  A
1 =ACOS( -1 )
2 =ACOS( 0 )
3 =ACOS( 1 / SQRT(2) )
4 =DEGREES( ACOS( 1 / SQRT(2) ) )
 Results
  A B
1 3.141592654 - Result is π radians
2 1.570796327 - Result is π/2 radians
3 0.785398163 - Result is π/4 radians
4 45 - Result is 45 degrees


Further information and examples of the Excel Acos function can be found on the Microsoft Office website.


Common Error

If you get the #NUM! error from your Excel Acos function this is likely to be because the supplied Number argument is not in the range -1 to +1.







Valid XHTML 1.0 Transitional

Disclaimer Privacy Policy

Copyright © 2008-2011 ExcelFunctions.net