Excel functions / Math

ATANH function

The inverse hyperbolic tangent of a number.

Syntax

=ATANH(number)

Arguments

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

  1. Undo TANH

    ABC
    1x
    20.50.5

    In C2: =ATANH(TANH(A2)) → 0.5

    Try this example

Common mistakes

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.

Translate a whole formula

Try ATANH in the playground

Related functions