Excel TANH Function

The Excel TANH function returns hyperbolic tangent of a number. The hyperbolic tangent of x is defined as:

where e is an Euler's number.

The TANH function is a built-in function in Excel that is categorized as a Math/Trig Function. It can be used as a worksheet function in Excel. As a worksheet function, the TANH function can be used as part of a formula in a worksheet cell.

Syntax

TANH(number)

Parameters

Return Value

Returns the hyperbolic tangent of a value.

Notes

• If the argument is a non-numeric value, TANH returns #VALUE! error.

Example: Using as Worksheet Function

The example below shows how to use the TANH function as worksheet function.

Based on the Excel spreadsheet above, the output of the following worksheet formula will be:

=TANH(B5)
Result: -0.999999996

=TANH(B6)
Result: -0.761594156

=TANH(B7)
Result: -0.462117157

=TANH(B8)
Result: 0

=TANH(B9)
Result: 0.462117157

=TANH(B10)
Result: 0.761594156

=TANH(B11)
Result: 0.999999996