The Excel ACOTH Function

Related Function:
COTH Function
Hyperbolic Arccotangent

The hyperbolic arccotangent is the inverse of the hyperbolic cotangent. Therefore,

ACOTH( COTH( x ) ) = x

The equation used to calculate the hyperbolic arccotangent is:

Hyperbolic Arccotangent Equation
Further information on the inverse hyperbolic functions is provided on Wikipedia.

Function Description

The Excel Acoth function calculates the hyperbolic arccotangent (coth) of a supplied value.

Note: the Acoth function was only introduced in Excel 2013 and so is not available in earlier versions of Excel.

The syntax of the function is:

ACOTH( number )

Where the number argument is the value that you want to calculate the hyperbolic arccotangent of. This must be less than -1 or greater than +1.


Acoth Function Examples

The following spreadsheet shows the Excel Acoth Function, used to calculate the hyperbolic arccotangent of three different values:

 Formulas:
  A
1 =ACOTH( -5 )
2 =ACOTH( 1.1 )
3 =ACOTH( 2 )
 Results:
  A
1 -0.202732554
2 1.522261219
3 0.549306144

For further details and examples of the Excel Acoth function, see the Microsoft Office website.


Acoth Function Errors

If you get an error from the Excel Acoth function, this is likely to be one of the following:

Common Errors
#NUM! - Occurs if the supplied number is between -1 and +1 (inclusive).
#VALUE! - Occurs if the supplied number argument is not recognized as a numeric value.