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.
|number||The angle, in radians, for which you want the cotangent
|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|
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|
The 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:
See Wikipedia for more information on Trigonometric Ratios