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(-PI) = 8.16 E15 (very large)
2=COT(PI()/2) = 0
3=COT(PI()/4) = 1
4=COT(RADIANS(45)) = 1
5=COT(0.5)=1/TAN(0.5) = True
6=COT(0.5) = COS(0.5)/SIN(0.5) = True
7=COT(ACOT(0.014)) = 0.014
8=COT("text") = #VALUE!
9=COT(0) = #DIV/0!
10=COT(2E+29) = #NUM!

1 - What is the cotangent of 0 radians.

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