Skip to content
Excel

TANH function in Excel

Returns the hyperbolic tangent of a number

=TANH(number)

TANH syntax and parameters

One argument, one required.

  • numbernumberRequired

    Any real number.

TANH examples

Formulas you'll actually reuse.

  1. Hyperbolic tangent — squashes any input into −1…1:

    =TANH(B2)

    Result0.7616

  2. A soft 0–100 score from an unbounded input:

    =TANH(B2 / 2) * 100

    Result46.21

TANH in Google Sheets

Same name — your formula ports as-is.

Try TANH in the playground

Edit the example — nothing to install.

Preloaded with the TANH formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Excel gets this done.