ACOTH function
ACOTH returns the inverse hyperbolic cotangent of a number, reversing COTH. It is a niche function used mainly for math and engineering work, and values between -1 and 1 return #NUM!.
Example
Read it as a sentence: find the inverse hyperbolic cotangent of the number in E1, which is 5.
Excel shows 0.202732554
E
1
5
Data
Syntax
ACOTH(number)
-
number(required) - A number whose absolute value is greater than 1.
Returns: The inverse hyperbolic cotangent.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=ACOTH(2) | 0.549306144 | Larger value |
=ACOTH(-2) | -0.549306144 | Domain: -2 |
=ACOTH(1.0001) | 4.951768776 | Domain: 1.0001 |
=ACOTH(Data!E1) | 0.202732554 | Text-number cell |
=ACOTH(0.5) | #NUM! | Positive |
=ACOTH(0) | #NUM! | Zero |
=ACOTH(-0.5) | #NUM! | Negative |
=ACOTH("0.5") | #NUM! | Text number "0.5" |
The Data sheet these formulas read
A cell that starts with = holds that formula.
E
1
5
Data
Watch out for
- Values between -1 and 1 return #NUM!.
Where it works
- Excel
- ACOTH arrived in Excel 2013. Older versions do not have it.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Math and trig functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .