Microsoft Office Development and Consultancy
 Home|

Excel

|VBA|C#|Finance|Tools|Newsletter|Feedback|Contact 
 Excel > Functions > Maths and Trigonometry > ACOS

 

ACOS(number)

 
 Returns the arccosine of a number in radians.

 numberThe number you want the arccosine of.

 REMARKS
 
  • The arccosine of an angle is the inverse of the COS function.
     
  • The "number" is the cosine of an angle in radians.
     
  • If "number" is not numeric, then #VALUE! is returned.
     
  • The returned angle is given in radians between 0 and PI.
     
  • If your argument is in degrees, multiply it by PI/180 to convert it to radians.
     
  • If you want to convert the result from radians to degrees, multiply it by 180/PI.
     
  • You can use the DEGREES function to convert from radians to degrees.
     
  • Example 1 -
     
  • Example 2 -
     
  • Example 3 -
     
  • Example 4 -
     
  • Example 5 -
     
  • Example 6 -
     
  • Example 7 -

     EXAMPLES
     
     A
    1=ACOS(0.5) = 1.047
    2=ACOS(-1) = 3.142
    3=ACOS(1) = 0
    4=ACOS(COS(1)) = 1
    5=ACOS(COS(0.5)) = 0.5
    6=ACOS(-0.5)*180/PI() = 120
    7=ACOS(-1)*180/PI() = 180
    8=DEGREES(ACOS(-1)) = 180
    9=ACOS(DEGREES(-0.5)*PI()/180)*180/PI() = 120
    10=ACOS(10) = #NUM!
    11=ACOS("some text") = #VALUE!
     

     Functions - A | Index - A | Office Online 2013 | 2010 | 2007 | 2003 

     © Better Solutions Limited 04-Jun-2013Top