The Excel TANH Function
Basic Description
The Excel TANH function calculates the hyperbolic tangent (tanh) of a supplied number.
The format of the function is :
TANH( number )
Where the number argument is the real number that you want to calculate the tanh of.
This can be input to the function either :
| - | directly |
| - | as a value returned from another function or formula, or |
| - | as a reference to a cell containing a value |
Examples
Column B of the spreadsheet below, shows examples of the Excel Tanh Function, used to calculate the
hyperbolic tangent of three different values.
The formulas are shown in the spreadsheet on the left and the results are shown in the spreadsheet
on the right.
Formulas:
|
Results:
|
|
Hyperbolic Functions
The basic hyperbolic functions,
cosh, sinh and tanh are related to the equilateral hyperbola, x 2-y 2=1.
If the area between a line through the origin, the x-axis, and the hyperbola x2-y2=1
has area α/2, then:
-
cosh α is the x coordinate of the intersection between the line through the origin and the
hyperbola x2-y2=1
-
sinh α is the y coordinate of the intersection between the line through the origin and the
hyperbola x2-y2=1
-
tanh α is equal to sinh α / cosh α
The equation used to calculate the hyperbolic tangent is therefore:
|
Further information and examples of the Excel Tanh function can be found on the
Microsoft Office website.
