GET Cotangent Value using COT Function in Excel

The COT function in Excel calculates and returns the cotangent of a given radians. COT is the reciprocal of TAN.

Trigonometric Function in Excelcot(θ) = Adjacent / Opposite = b/a

Cot of the angle θ, is the ratio of the adjacent side – b to the opposite site a.

 

Syntax of COT Function in Excel

COT(number)

Where Argument number is angle in radians which you need to calculate the cotangent of.

NOTE: If your angle is in degrees, you will need to convert it into radians before supplying it to the COT Function with the help of Radians function

=RADIANS( degrees )

 

Example of COT Function in Excel

Formula

COT Function in Excel 1

  • In Row number 2 and 3 the radians value is passed to the COT Function
  • In row number 4, Angle 60 degree is converted to radians and passed as input to the COT Function.
  • In Row number 5 Radians -π/6 is passed as input to the COT Function.
  • In row number 6, Angle -90 degree is converted to radians and passed as input to the COT Function.

 

Result

COT Function in Excel 2

previous-small COT Function in Excel                                                                                                           next_small COT Function in Excel