How to use the ATANH Function in Excel office 365?
Tags: tousetheatanhfunctio, excel, excelfunctions
Published: 2021-08-26 08:56:19

---
title: How to use the ATANH Function in Excel office 365?
published: true
date: 2021-08-24 16:03:32 UTC
tags: ToUseTheATANHFunctio,Excel,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-the-atanh-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 ATANH**  **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)**

## ATANH Function

ATANH function in Excel returns the inverse of the Tangent hyperbolic function in Excel.

## ATANH Function Syntax

```
= ATANH ( number )
```

**Syntax Explanation:**

**number:** input any real number between -1 and +1 (excluding -1 & +1).

## Example

- 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-29.png)<figcaption>Sample data</figcaption>

- Then, you need to find the **inverse of the hyperbolic Tangent**  **value** using the **ATANH**  **function** in Excel.
- 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/ATANH-Function.png)<figcaption>ATANH function</figcaption>

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

```
x = TANH -1 (e0- e0) / (e0+ e0) = TANH -1( 0 ) = 0
```

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

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

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

**Check this too** :

- [How to Use Excel ATAN Function in Office 365? – (with Examples)](https://geekexcel.com/how-to-use-excel-atan-function-in-office-365-with-examples/)
- [How to Use Excel ATAN2 Function in Office 365? – {with Examples}](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 function returns **#NUM error** , 
  - if the argument number is less than or equal to 1.
  - If the argument number is greater than or equal to 1.
- **Argument** to the function can be provided **directly** or using the **cell reference** in Excel.

## Closure

We hope that this short tutorial gives you guidelines to **use the ATANH 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:**

- **[Find the Last Column of Data in Excel Office 365?](https://geekexcel.com/how-to-find-the-last-column-of-data-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 Hide a Worksheet in Microsoft Excel 365?](https://geekexcel.com/how-to-hide-a-worksheet-in-microsoft-excel-365/)**
- **[Excel Date and Time Functions in Office 365!!](https://geekexcel.com/date-and-time-functions-in-microsoft-excel-365/)**