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:


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.

Graphs courtesy of

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.