Excel functions / Math
ATANH function
The inverse hyperbolic tangent of a number.
Syntax
=ATANH(number)
Arguments
number: A number between -1 and 1.
When to use it
ATANH gives the number whose hyperbolic tangent is the one given, which must be between -1 and 1. It is the same calculation as FISHER.
Examples
Undo TANH
A B C 1 x 2 0.5 0.5 In C2:
=ATANH(TANH(A2))→ 0.5
Common mistakes
- Outside -1 to 1. ATANH of 1 or more is #NUM!.
ATANH in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: ARCTGH
- Danish: ARCTANH
- Dutch: BOOGTANH
- Finnish: ATANH
- French: ATANH
- German: ARCTANHYP
- Hungarian: ATANH
- Italian: ARCTANH
- Norwegian: ARCTANH
- Polish: ATANH
- Portuguese (Brazil): ATANH
- Portuguese (Portugal): ATANH
- Russian: ATANH
- Spanish: ATANH
- Swedish: ARCTANH
- Turkish: ATANH