## What is the ASIN Function in Excel?

The **ASIN **function is one of the math functions of Excel. It returns the **arcsine **of a number in radians, in the range -Pi/2 to Pi/2.

The **arcsine **is the angle whose sine is a Number. The domain of arcsine is the interval [−1,1] and it is undefined elsewhere.

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

## How to use **ASIN **function in excel

- Click on an empty cell (like F5 )

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

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

4. Select **math and trig** category

5. Select **ASIN **function

6. Then select **ok**

7. In the function arguments Tab you will see ** ASIN **function

8. Is the sine of the angle you want and must be from -1 to 1

9. You will see the result in the formula result ( **ASIN** (0)=0)

## Examples of **ASIN **function in excel

**Example 1:**

**How to use ASIN function in excel**

You can see examples of ASIN function below:

**asin**(-1) ----->>>>answer is -1.570
**asin**(-0.5) ----->>>>answer is -0.523
**asin**(0) ----->>>>answer is 0
**asin**(0.5) ----->>>>answer is 0.523
**asin**(1) ----->>>>answer is 1.570

math.asin(a)

### How to plot Y=**ASIN**(X) with python code in excel

**ASIN**

```
import math
import numpy as np
import matplotlib.pyplot as plt
x =np.linspace(-1,+1, 100)
lenx=len(x)
y=[]
for i in range(lenx):
y.append(math.asin(x[i]))
i +=1
plt.plot(x,y)
plt.show()
```

## What is the purpose of **ASIN** function?

**ASIN**

It returns the **arcsine **of a number in radians, in the range -Pi/2 to Pi/2.

## What is the Return value of **ASIN** function?

**ASIN**

It can return any type of data.

## How many arguments does **ASIN** function have?

**ASIN**

This function has just **1** Argument.

The **argument **of ASIN function is **number**.

Is the sine of the angle you want and must be from -1 to 1.

The argument of ASIN function is **required **and not optional.

```
ASIN(number) = number
```

## Which version of excel supports **ASIN** function?

**ASIN**

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

## Errors in **ASIN** function

**ASIN**