ACOS

ACOS(number)

Returns the angle in radians for a given cosine ratio.

number

The 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

	A	B
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