ATANH function
ATANH returns the inverse hyperbolic tangent of a number, reversing TANH. It appears in some statistical transformations, and -1, 1 or anything beyond returns #NUM!.
Example
Read it as a sentence: find the inverse hyperbolic tangent of 0.5.
A
B
C
D
1
0.549306144
2
3
Syntax
ATANH(number)
-
number(required) - A number strictly between -1 and 1.
Returns: The inverse hyperbolic tangent.
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 |
|---|---|---|
=ATANH(0.5) | 0.549306144 | Positive |
=ATANH(0) | 0 | Zero |
=ATANH(-0.5) | -0.549306144 | Negative |
=ATANH("0.5") | 0.549306144 | Text number "0.5" |
=ATANH({0.1,0.2}) | 0.100335348 | Array constant spills |
=ATANH(0.9999) | 4.951718776 | Domain: 0.9999 |
=ATANH(2) | #NUM! | Larger value |
=ATANH("abc") | #VALUE! | Non-numeric text |
Watch out for
- -1, 1 and anything beyond return #NUM!.
Where it works
- Excel
- ATANH is in every version of Excel from 2007 on.
- 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 .