Excel functions / Math
TANH function
The hyperbolic tangent of a number.
Syntax
=TANH(number)
Arguments
number: Any number.
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
Squash values into -1 to 1
A B C 1 x 2 2 0.9640 In C2:
=TANH(A2)→ 0.9640
Common mistakes
- Not an angle. TANH takes any number, not an angle.
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.
- Czech: TGH
- Danish: TANH
- Dutch: TANH
- Finnish: TANH
- French: TANH
- German: TANHYP
- Hungarian: TANH
- Italian: TANH
- Norwegian: TANH
- Polish: TANH
- Portuguese (Brazil): TANH
- Portuguese (Portugal): TANH
- Russian: TANH
- Spanish: TANH
- Swedish: TANH
- Turkish: TANH