Excel Functions Tutorials
- Maths Functions in Excel
- ABS Function in Excel
- AGGREGATE Excel Function
- CEILING Excel Function
- COMBIN Excel Function
- COS Excel Function
- EVEN Function in Excel
- EXPONENTIAL Excel Function
- Excel Matrix Multiplication
- Excel Minus Formula
- FLOOR Function in Excel
- Histogram Formula
- INT Excel Function (Integer)
- LN Excel Function
- LOG Excel Function
- Mode in Excel
- ODD Function in Excel
- POWER Function in Excel
- PRODUCT Excel Function
- PRODUCT Formula in Excel
- PI in Excel
- Quotient in Excel
- Running Total in Excel
- RAND Excel Function
- Rand Excel Formula
- RANDBETWEEN in Excel
- MROUND in Excel
- ROUND in Excel
- ROUND Formula in Excel
- ROUNDDOWN Excel Function
- ROUNDUP Function in Excel
- SIGN Excel Function
- SIN Excel Function
- Square Root in Excel (SQRT)
- SUBTOTAL Excel Function
- SUM Function in Excel
- SUM Formula in Excel
- Excel SUM Shortcut
- SUMIF in Excel
- SUMIFS in Excel
- SUMIF Not Blank
- SUMIFS with Dates
- SUMIF Between Two Dates
- Sumif Text in Excel
- SumIf with Multiple Criteria
- SUMPRODUCT Function in Excel
- SUMPRODUCT Formula in Excel
- SUMPRODUCT with Multiple Criteria
- How to Sum Multiple Rows in Excel?
- TAN Excel Function
- TANH in Excel
- Average vs Weighted Average
- Financial Functions in Excel (17+)
- Logical Functions in Excel (15+)
- TEXT Functions in Excel (29+)
- Lookup Reference in Excel (44+)
- Date and Time Function in Excel (22+)
- Statistical Function in Excel (50+)
- Information Functions in Excel (5+)
- Excel Charts (48+)
- Excel Tools (98+)
- Excel Tips (178+)
- VBA (162+)
- Power Bi (35+)
In trigonometry we have a termed called hyperbolic tangent which is the ratio of the hyperbolic sine and cosine functions, to calculate this mathematical operation in excel we have an inbuilt trigonometric function known as TANH and it takes single argument as an input.
TANH Function in Excel (Table of Contents)
TANH Function in Excel
TANH function is categories as Math or Trig function in excel returns the hyperbolic tangent function of the given number. So you can use this function to calculate the hyperbolic tangent function of a number in Excel.
This function is available in all versions of excel i.e. Excel 2016, Excel 2013, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000, and Excel 2011 for Mac.
TANH Formula in Excel
TANH formula in Excel has only one compulsory parameter i.e. number.
- number: Number is any real number or a numeric value used to determine the hyperbolic tangent Function.
The formula for the TANH (Hyperbolic tangent) is:
How to Use TANH Formula in Excel?
This function is very simple and easy to use. Let understand the working of TANH by some examples. TANH function can be used as a worksheet function and as VBA function.
TANH Function as Worksheet Function.
Let’s 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 on 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.
In this TANH example, we take the sample of negative angles (in radian) and then apply the TANH formula on them.
Let’s 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 on TANH. Now apply the TANH in cell as shown in the below table. TANH 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.
Suppose you have the angle in degree then you have to convert the degree to radian by using the RADIAN function as shown in the below table than apply the TANH formula to calculate the hyperbolic tangent Function of the given angle.
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 than apply the TANH formula to calculate the hyperbolic tangent Function of the given angle.
Suppose the given angle is in degree and you want hyperbolic tangent function in degree then you have to first convert the degree angle to radian by radian() function or multiplying it by PI()/180 and apply the TANH formula now out 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.
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 About the TANH Function in Excel
- If the supplied number is nonnumeric 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 has been a guide to TANH Function in Excel. Here we discuss the TANH Formula in excel and how to use TANH along with excel example and downloadable excel templates. You may also look at these useful functions in excel –