ASINH function in Excel

What is the ASINH function in Excel?

The ASINH function is one of the math functions of Excel. It returns the inverse hyperbolic sine of a number.

We can find this function in Math&trig of insert function Tab.

How to use ASINH function in excel

  1. Click on an empty cell (like F5 )
Click on an empty cell

2. Click on the fx icon (or press shift+F3)

Click on the fx icon

3. In the insert function tab you will see all functions

In insert function tab you will see all functions

4. Select math and trig category

5. Select the ASINH function

6. Then select ok

Select math and trig category

7. In the function arguments Tab you will see the ASINH function

8. In the Number section you can enter any real number in(-R, R)

9. You will see the result in the formula result section ( ASINH (0)=0)

How to use ASINH function in excel

Examples of ASINH function in excel

Example 1:

How to use ASINH function in excel

You can see examples of ASINH function below:

 examples of ASINH function in excel
asinh(0) ----->>>>answer is  0.881

asinh(10) ----->>>>answer is  2.998

asinh(100) ----->>>>answer is   5.298

asinh(1000) ----->>>>answer is  7.600

asinh(10000) ----->>>>answer is   9.903

math.asinh(a)

How to plot Y=ASINH(X) with python code in excel

import math 

import numpy as np

import matplotlib.pyplot as plt

x =np.linspace(-100,100, 1000)

lenx=len(x)

y=[]

for i in range(lenx):     

y.append(math.asinh(x[i]))     

i +=1    

plt.plot(x,y)  

plt.show() 

What is the purpose of ASINH function?

It returns the inverse hyperbolic sine of a number.

What is the Return value of ASINH function?

It returns a number.

How many arguments does ASINH function have?

This function has just 1 Argument.

The argument of ASINH function is number.

In the Number section you can enter any real number in(-R, R)

The argument of ASINH function is required and not optional.

ASINH(number) = number

Which version of excel supports ASINH function?

This function is available for all excel versions (2003-2019)

Errors in ASINH function

ASINH related functions :

Leave a Reply

Your email address will not be published. Required fields are marked *