TANH()

Syntax. TANH(number)

Definition. This function returns the hyperbolic tangent of a number.

Argument

  • number (required) Any real number

Background. The hyperbolic tangent belongs to the hyperbolic functions, which are (like the circle functions) defined for all real and complex numbers. (However, Excel allows only real arguments, not complex arguments, for hyperbolic functions.)

The formula for the hyperbolic tangent is:

image with no caption

The last term shows the similarity with the trigonometry functions.

The hyperbolic tangent is often used for research and development in engineering and natural sciences (see Figure 16-40).

Figure 16-40. The hyperbolic tangent.

You ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.