- Advanced Excel Functions Tutorial
- Advanced Excel Functions - Home
- Compatibility Functions
- Advanced Excel Functions - Cube
- Database Functions
- Date & Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Advanced Excel Functions - Logical
- Lookup & Reference Functions
- Math & Trignometric Functions
- Statistical Functions
- Useful Resources
- Quick Guide
- Useful Resources
- Discussion
Math and Trignometric - ACOTH Function
Description
The ACOTH function returns the inverse hyperbolic cotangent of a number.
Syntax
ACOTH (number)
Arguments
Argument | Description | Required/Optional |
---|---|---|
Number | The absolute value of Number must be greater than 1. i.e., Number must be must be less than -1 or greater than +1. | Required |
Notes
The equation used to calculate the hyperbolic arccotangent is −
$$a\coth\left ( x \right ) = \frac{1}{2} Ln\frac{\left ( x + 1 \right )}{\left ( x - 1 \right )}$$
The hyperbolic arccotangent is an analog of the ordinary (circular) arccotangent.
If Number is less than 1, ACOTH returns the #NUM! error value.
If the absolute value of Number is less than 1, ACOT returns the #VALUE! error value.
Applicability
Excel 2013, Excel 2016
Example
advanced_excel_math_trigonometric_functions.htm
Advertisements