Summary

The Excel ACOT function returns the arc cotangent of a number.

Purpose 

Get arccotangent of a number.

Return value 

The angle in radians.

Syntax

=ACOT(number)
  • number - The value of the cotangent of an angle.

How to use 

The Excel ACOT function returns the arc cotangent of a number. Given the input 1, the function returns 0.785398163 radians as the output.

=ACOT(1) // Returns 0.785398163 radians

Explanation

The arc cotangent function is the inverse of the cotangent function, with a branch cut that maps to related angles.

=ACOT(COT(a)) // returns the angle or a branch cut angle

For example, the angle π/4 is mapped to π/4 with no branch cut.

=ACOT(COT(PI()/4)) // returns π/4

Where the angle -π/2 is mapped to positive π/2 with a branch cut.

=ACOT(COT(-PI()/2)) // returns positive π/2

In Excel, when we talk about ACOT as the inverse of COT, angles outside the range of 0 to π are mapped with a branch cut. Below is the output of the cotangent function with the branch cut highlighted.

Cotangent plot with highlighted branch cut.

Other implementations of the function may have different branch cuts. Below is the plot of the output of the ACOT function in Excel.

Arc cotangent plot.

Images courtesy of wumbo.net.

 

Dave Bruns Profile Picture

AuthorMicrosoft Most Valuable Professional Award

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.