How to use the TANH Function in Excel office 365?
Tags: tousethetanhfunction, excel, excelfunctions
Published: 2021-09-01 07:08:01

---
title: How to use the TANH Function in Excel office 365?
published: true
date: 2021-08-31 14:59:08 UTC
tags: ToUseTheTANHFunction,Excel,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-the-tanh-function-in-excel-office-365/
---

 **TANH function** is a **Mathematical function** to calculate the **hyperbolic Tangent of the value** , and it is a **built-in** Excel function. The hyperbolic function of TANH is defined using the **exponential function**. In this tutorial, we will guide you on **how to use the TANH**  **Function In Excel Office 365**. Let’s get them below!! Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

## TANH Function Syntax

```
= TANH ( number )
```

**Syntax Explanation:**

**number:** input number you want the hyperbolic Tangent of.

## Example1

- You have to **create a sample data** with values which will be **input** to the function.

![](https://geekexcel.com/wp-content/uploads/2021/08/Sample-data-48.png)<figcaption>Sample data</figcaption>

- Then, you need to find its **hyperbolic Tangent value**.
- Now, you have to use the following **formula** given below.

```
=TANH ( A2 )
```

**A2:** the number is given as cell reference.

![](https://geekexcel.com/wp-content/uploads/2021/08/TANH-Function.png)<figcaption>TANH Function</figcaption>

- After that, the **value** will **calculate ** using the **mathematical formula.**

```
TANH (x) = (e1- e-1) / (e1+ e-1)
```

- You need to **copy the formula** to **other cells** using the  **Ctrl + D**  shortcut key.

![](https://geekexcel.com/wp-content/uploads/2021/08/Copy-to-other-cells-6.png)<figcaption>Copy to other cells</figcaption>

- Finally, **Excel** calculates the **Hyperbolic Tangent**  **of a number** using the **TANH**.

## Example2

- You have to **create a sample data** with values which will be **input** to the function.

![](https://geekexcel.com/wp-content/uploads/2021/08/Ex-2-Sample-data-8.png)<figcaption>Sample data</figcaption>

- Then, you need to find its **hyperbolic Tangent value**.
- Now, you have to use the following **formula** given below.

```
=TANH ( A2 )
```

**A2:** the number is given as cell reference.

![](https://geekexcel.com/wp-content/uploads/2021/08/Ex-2-TANH-Function.png)<figcaption>TANH Function</figcaption>

- After that, the **value** will **calculate ** using the **mathematical formula.**

```
TANH (x) = (e1- e-1) / (e1+ e-1)
```

- You need to **copy the formula** to **other cells** using the  **Ctrl + D**  shortcut key.

![](https://geekexcel.com/wp-content/uploads/2021/08/Ex-2-Copy-to-other-cells-4.png)<figcaption>Copy to other cells</figcaption>

- Finally, **Excel** calculates the **Hyperbolic Tangent**  **of a number** using the **TANH function**.

**Check this too:**

- [ATANH Function](https://geekexcel.com/how-to-use-the-atanh-function-in-excel-office-365/)
- [IMTAN Function](https://geekexcel.com/how-to-use-the-imtan-function-in-excel-office-365/)
- [ATAN2 Function](https://geekexcel.com/how-to-use-excel-atan2-function-in-office-365-with-examples/)

**NOTE:**

- The function returns **#VALUE! Error** if the argument to the function is **non – numeric**.
- The **input number** is the **angle in radians**.
- If you want the **result in degrees** , **multiply** the result by **180/PI ().**
- If the **argument** provided is in **degrees** , first **multiply the number in degrees** by **PI ()/180** to convert it into **radians**.

## Closure

We hope that this short tutorial gives you guidelines to **use the TANH Function In Excel Office 365. ** Please leave a comment in case of any **queries,** and don’t forget to mention your valuable **suggestions** as well. Thank you so much for Visiting Our Site!! Continue learning on **[Geek Excel](https://geekexcel.com/)!! **Read more on [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

**Keep Reading:**

- **[How to use the ATANH Function in Excel office 365?](https://geekexcel.com/how-to-use-the-atanh-function-in-excel-office-365/)**
- **[How to use ASIN Function in Microsoft Excel 365?](https://geekexcel.com/how-to-use-asin-function-in-microsoft-excel-365/)**
- **[use the F.DIST function in Excel office 365](https://geekexcel.com/how-to-use-the-f-dist-function-in-excel-office-365/)**
- **[How to use the ASINH Function in Excel office 365?](https://geekexcel.com/how-to-use-the-asinh-function-in-excel-office-365/)**
- **[How to use the ACOSH Function in Excel office 365?](https://geekexcel.com/how-to-use-the-acosh-function-in-excel-office-365/)**