The COT function return the cotangent of an angle specified in radians.

  • This function was introduced in Excel 2013 and so is not available in earlier versions.




Argument Description
number The angle, in radians, for which you want the cotangent

  The absolute value of number must be less than 2^27


  A B C
1 Formula Result Notes
2 =COT(30) -0.156 Returns the cotangent of 30
3 =COT(A6) 0.617 Returns the cotangent of 45
4 =COT(RADIANS(45)) 1 Returns the cotangent of 45 degrees
6 45    

Note: If the angle is in degrees, you need to be convert it to radians before supplying it to the COT function. You can convert it, using the RADIANS function: =RADIANS(degrees)

Common Function Error(s)

Problem What went wrong
#VALUE! Occurs if the supplied number argument is equal to zero
#NUM! Occurs if the supplied number argument is less than -2^27 or is greater than 2^27
#DIV/0! Occurs if the supplied number argument is not recognized as a numeric value

trigonometry_triangleThe cotangent is the reciprocal of the tangent. For the simple right-angle triangle at with, the cotangent of the angle A is equal to the adjacent side (b), divided by the opposite side (a). The formula for calculating cotangent is:  

    \[   cot(A) = \frac 1{tan(A)} = \frac b{a}    \]

See Wikipedia for more information on Trigonometric Ratios