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.570math.asin(a)
How to plot Y=ASIN(X) with python code in excel
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?
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?
It can return any type of data.
How many arguments does ASIN function have?
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?
This function is available for all excel versions (2003-2019)
