Purpose
Return value
Syntax
=ACOT(number)
- number - The value of the cotangent of an angle.
Using the ACOT function
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.
Other implementations of the function may have different branch cuts. Below is the plot of the output of the ACOT function in Excel.
Images courtesy of wumbo.net .
Purpose
Return value
Syntax
=ACOTH(number)
- number - The number to get the inverse hyperbolic cotangent of.
Using the ACOTH function
The Excel ACOTH function returns the inverse hyperbolic cotangent of a number. Given 2 as input, the function returns 0.549306144 as output.
=ACOTH(2) // returns 0.549306144
Explanation
The hyperbolic arc cotangent function is the inverse of the COTH function.
=ACOTH(COTH(x)) // returns x when x ≠ 0
The plot below shows the ACOTH function’s output in Excel.
Notes:
- The function returns a #NUM! Error for input greater than or equal to -1 and less than or equal to 1.
Image(s) courtesy of wumbo.net .
