TANH Function in Excel

Article byTanuj Kumar
Reviewed byDheeraj Vaidya, CFA, FRM

TANH Function in Excel

In trigonometry, we have a term called hyperbolic tangent, which is the ratio of the hyperbolic sine and cosine functions. To calculate this mathematical operation in Excel, we have a built-in trigonometric function known as TANH. It takes a single argument as input.

For example, to get the TANH of 80 degrees present in cell A1, we can use the formulae below:

=TANH(A1)

=1.

To multiply it by PI ()/180, we must use the below formula:

= =TANH((A1*(PI()/180)))

=    0.884541.

Syntax

TANH Formula in Excel

It has only one critical parameter: number.

Compulsory Parameter:

  • number: A number is any real number or the numeric value used to determine the hyperbolic tangent function.

Remark

The formula for the TANH (Hyperbolic tangent) is:

TANH(x) =SINH(x)/COSH(x)

–>> If you want to learn Excel and VBA professionally, then ​Excel VBA All in One Courses Bundle​ (35+ hours) is the perfect solution. Whether you’re a beginner or an experienced user, this bundle covers it all – from Basic Excel to Advanced Excel, Macros, Power Query, and VBA.

How to Use TANH Formula in Excel?

You can download this TANH Function Excel Template here – TANH Function Excel Template

Example #1

Let us consider a set of angles (in radian) 0, 0.5, 1, 1.5, 2, 2.5, 3, 3.5, 4, and 5 to understand the working of TANH.

Now, apply the TANH in the cell, as shown in the below table. TANH will return the hyperbolic tangent function of all the supplied values as 0, 0.46, 0.76, 0.91, 0.96, 0.99, 1.00, 1.00, 1.00 and 1.00.

TANH Example 1

Example #2

In this TANH example, we take the sample of negative angles (in radian) and then apply the TANH formula to them.

Let us consider a set of positive integers -0.1, -0.5, -1, -1.5, -2, -2.5, -3, -3.5, -4 and -5 to understand the working of TANH. Now, apply the TANH in the cell as shown in the below table. The TANH function provides the hyperbolic tangent function as -0.10, -0.46, -0.76, -0.91, -0.96, -0.99, -1.00, -1.00, -1.00 and -1.00.

Example 2

Example #3

Suppose you have the angle in degree, then you have to convert the degree to radian by using the RADIAN function as shown below table, then apply the TANH formula to calculate the hyperbolic tangent function of the given angle.

Example 3

Example #4

Suppose you have the angle in degree, then you have to convert the degree to radian, multiplying the degree angle to PI/180, as shown in the below table, then apply the TANH formula to calculate the hyperbolic tangent function of the given angle.

Example 4

Example #5

Suppose the given angle is in degree, and you want a hyperbolic tangent function. Then, you must first convert the degree angle to radian by RADIAN() function or multiply it by PI()/180 and apply the TANH formula. Now, the output will be in radian at the end, reverse the process and multiply the output angle 180/PI() to convert the output angle into the degree.

Example 5

TANH Function can be used as a VBA function.

Dim TANHnumber As Long

TANHnumber = Application.worksheetfunction.TANH(“0”)

Msgbox(TANHnumber) // Return the nearest TANH value in message box.

The output will be “0” and printed in the message box.

Things to Remember

  • If the supplied number is a non-numeric value, then TANH will return the #VALUE! Error.
  • The number is the angle in radians.
  • If the number is in degrees, multiply it by PI/180 to convert it into radians.
  • If you want the result in a degree, multiply the result by 180/PI.

This article has been a guide to TANH Function in Excel. We discuss using TANH in Excel, examples, and downloadable templates here. You may also look at these useful functions in Excel:-