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.

Syntax

=COT(number)

Arguments

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

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

Examples

  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
5      
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