Quick, clean, and to the point

Excel COT Function

Excel COT function
The Excel COT function returns the cotangent of an angle provided in radians.
Get the cotangent of an angle.
Return value 
The cotangent value.
=COT (number)
  • number - The angle provided in radians.
Usage notes 

The Excel COT function returns the cotangent of an angle provided in radians. In geometric terms, the cotangent of an angle returns the ratio of the length of the adjacent side over the length of the opposite side of the corresponding right triangle. For example, the cotangent of PI()/6 (30°) returns the ratio 1.732.

=COT(PI()/6) // Returns 1.732

Using Degrees

To supply an angle to COT in degrees, multiply the angle by PI()/180 or use the RADIANS function to convert to radians. For example, to get the COT of 60 degrees, you can use either formula below:



Graph of Cotangent Function

The graph of COT, shown above, visualizes the output of the function for angles from 0 to a full rotation. The function has vertical asymptotes at the points 0, π, and 2π where the output of the function diverges to infinity. The COT function is the reciprocal of TAN and can be equivalently defined in the formula below:


The reciprocal relationship between COT and TAN is visualized by the graph shown below of both of the functions plotted together.

Graph of Cotangent and Tangent Function

Graphs courtesy of wumbo.net.

Download 100+ Important Excel Functions

Get over 100 Excel Functions you should know in one handy PDF.

Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Charts video training course
Video training for Excel Tables
Dynamic Array Formulas