COT

COT(number)

Returns the cotangent ratio of an angle.

numberThe angle in radians.

REMARKS
* For an illustrated example refer to the Trigonometric Functions page.
* This function returns the ratio ..
* If "number" is not numeric, then #VALUE! is returned.
* If "number" is zero, then #DIV/0! is returned.
* If "number" < -2 E10, then #NUM! is returned.
* If "number" > 2 E10, then #NUM! is returned.
* To convert a number from degrees to radians, multiply it by PI/180.
* To convert a number from radians to degrees, multiply it by 180/PI.
* You can use the COS function to return the cosine ratio for an angle.
* You can use the SIN function to return the sine ratio for an angle.
* You can use the TAN function to return the tangent ratio for an angle.
* You can use the RADIANS function to convert from degrees to radians.
* You can use the DEGREES function to convert from radians to degrees.
* You can use the ACOT function to return the angle in radians for a given cotangent ratio.
* You can use the CSC function to return the cosecant ratio for an angle.
* You can use the SEC function to return the secant ratio for an angle.
* You can use the IMCOT function to return the cotangent of a complex number.
* This function was added in Excel 2013.
* For the Microsoft documentation refer to support.microsoft.com

 A
1=COT(RADIANS(360)) = -4082809838298840.000
2=COT(RADIANS(270)) = 0.000
3=COT(RADIANS(180)) = -8165619676597690.000
4=COT(RADIANS(90)) = 0.000
5=COT(RADIANS(45)) = 1.000
6=COT(PI()/2) = 0
7=COT(PI()/4) = 1
8=COT(-PI) = 8.16 E15 (very large)
9=COT(0.5) = 1/TAN(0.5) = -1
10=COT(0.5) = COS(0.5)/SIN(0.5) = True
11=COT(ACOT(0.014)) = 0.014
12=COT("text") = #VALUE!
13=COT(0) = #DIV/0!
14=COT(2E+29) = #NUM!

1 - What is the cotangent ratio of an angle that is PI radians.

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