How to use the ASINH Function in Excel office 365?
Tags: tousetheasinhfunctio, excel, excelfunctions
Published: 2021-08-26 02:06:01

---
title: How to use the ASINH Function in Excel office 365?
published: true
date: 2021-08-23 15:58:48 UTC
tags: ToUseTheASINHFunctio,Excel,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-the-asinh-function-in-excel-office-365/
---

 **SINH function** is a **Mathematical function** to calculate the **hyperbolic sine of the value** , and it is a **built-in Excel function**. The hyperbolic function of SINH is defined using the **exponential function**. In this post, we will explain to you how to **use ASINH Function In Excel Office 365.** Let’s see 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)**

## ASINH function

**ASINH function** in Excel returns the **inverse of the sine hyperbolic function** in Excel.

## ASINH function Syntax

```
= ASINH ( number )
```

**Syntax Explanation:**

**number** : input any real number.

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

- Then, you need to find the **inverse of the hyperbolic sine value** using the **ASINH function** in Excel.
- Now, you have to use the following **formula** given below.

```
=SINH ( A2 )
```

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

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

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

```
x = SINH -1 (e0- e0) / 2  = SINH -1( 1 - 1 ) / 2 = SINH -10 = 0
```

- You need to **copy the formula** to **other cells** using the  **Ctrl + D**  shortcut key.
- Finally, **Excel** calculates the **inverse of the Hyperbolic sine of a number** using the **SINH function**.

**Check this too:** [How to use the TDIST function, T.DIST function, T.DIST.RT function & T.DIST.2T function in Excel?](https://geekexcel.com/how-to-use-the-tdist-function-t-dist-function-t-dist-rt-function-t-dist-2t-function-in-excel/)

**NOTE:**

- The function returns **#VALUE! Error** if the argument to the function is **non – numeric**.
- The **input argument** to the function can be any **real number**.
- **Argument** to the function can be provided **directly** or using the **cell reference** in Excel.

## Wrap-Up

Hope you understood how to **use ASINH Function In Excel Office 365**. Please feel free to state your query or feedback for the above article. Thank you for Reading!! To learn more, check out **[Geek Excel](https://geekexcel.com/)!! **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

**Read Also:**

- **[How to use the CONFIDENCE.NORM function in Excel office 365?](https://geekexcel.com/how-to-use-the-confidence-norm-function-in-excel-office-365/)**
- **[use the T.INV function in Excel office 365 – Easy Tricks!!](https://geekexcel.com/how-to-use-the-t-inv-function-in-excel-office-365-easy-tricks/)**
- **[How to use the LOGNORM.INV function in Excel office 365?](https://geekexcel.com/how-to-use-the-lognorm-inv-function-in-excel-office-365/)**
- **[Use Excel VALUE Function in Office 365](https://geekexcel.com/how-to-use-value-function-in-microsoft-excel-2013/)**
- **[How to add a secondary axis in Excel Office 365? – quick Tricks!!](https://geekexcel.com/how-to-add-a-secondary-axis-in-excel-office-365-quick-tricks/)**