Excel functions / Math

TANH function

The hyperbolic tangent of a number.

Syntax

=TANH(number)

Arguments

When to use it

TANH gives the hyperbolic tangent of a number: a smooth S-shaped curve from -1 to 1, used to squash values into that range.

Examples

  1. Squash values into -1 to 1

    ABC
    1x
    220.9640

    In C2: =TANH(A2) → 0.9640

    Try this example

Common mistakes

TANH 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 TANH in the playground

Related functions