ACOS

ACOS(number)

Returns the angle in radians for a given cosine ratio.

numberThe cosine ratio.

REMARKS
* For an illustrated example refer to the Trigonometric Functions page.
* This function always returns an angle between 0 and PI.
* If "number" is not numeric, then #VALUE! is returned.
* If "number" > 1, then #NUM! is returned.
* If "number" < -1, then #NUM! is returned.
* To convert a number from degress to radians, multiply it by PI/180.
* To convert a number from radians to degrees, multiply it by 180/PI.
* The inverse of this function is the COS function.
* You can use the COS function to return the cosine of a number.
* You can use the ACOT function to return the the arc-cotangent.
* You can use the ASIN function to return the arc-sine.
* You can use the ATAN function to return the arc-tangent.
* You can use the RADIANS function to convert from degrees to radians.
* You can use the DEGREES function to convert from radians to degrees.
* For the Microsoft documentation refer to support.microsoft.com

 AB
1=ACOS(-1) = 3.142=PI() = 3.14159265358979
2=ACOS(-0.5) = 2.094 
3=ACOS(0) = 1.571=PI()/2 = 1.5707963267949
4=ACOS(0.5) = 1.047 
5=ACOS(1) = 0.000 
6=ACOS(1.01) = #NUM! 
7=ACOS(0.5)*180/PI() = 60 
8=DEGREES(ACOS(0.5)) = 60 
9=ACOS(COS(0.5)) = 0.500 
10=ACOS("some text") = #VALUE! 

1 - What is the angle in radians for a cosine ratio of -1.
2 - What is the angle in radians for a cosine ratio of -0.5
3 - What is the angle in radians for a cosine ratio of 0
4 - What is the angle in radians for a cosine ratio of 0.5
5 - What is the angle in radians for a cosine ratio of 1
6 - When number is >1
7 - What is the angle in degrees for a cosine ratio of 0.5
8 - What is the angle in degrees for a cosine ratio of 0.5
9 - What is the inverse of cosine.
10 - When number is not numeric

© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited Top