ExcelExcel 2013+
ACOTH function in Excel
Returns the hyperbolic arccotangent of a number
=ACOTH(number)ACOTH syntax and parameters
One argument, one required.
- numbernumberRequired
ACOTH examples
Formulas you'll actually reuse.
Inverse hyperbolic cotangent — |x| must be greater than 1:
=ACOTH(B2)Result
0.5493Equal to ATANH of the reciprocal — the difference is zero:
=ACOTH(B2) - ATANH(1 / B2)Result
0
ACOTH in Google Sheets
Same name — your formula ports as-is.
Try ACOTH in the playground
Edit the example — nothing to install.
Preloaded with the ACOTH formula from Example 1 — change anything and watch it respond.
Loading the editor…
ACOTH errors
What they mean — and the fixes.
#NUM!|x| is 1 or less — ACOTH is only defined outside −1…1.
Related functions
More ways Excel gets this done.
- ABSReturns the absolute value of a numberMathGoogle Sheets
- ACOSReturns the arccosine of a numberMathGoogle Sheets
- ACOSHReturns the inverse hyperbolic cosine of a numberMathGoogle Sheets
- ACOTReturns the arccotangent of a numberMathGoogle Sheets
- AGGREGATEReturns an aggregate in a list or databaseMathNo Google Sheets equivalent
- ARABICConverts a Roman number to Arabic, as a numberMathGoogle Sheets