ASIN function in Excel

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

  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 (or press shift+F3)

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

In the insert function tab you will see all functions

4. Select math and trig category

5. Select ASIN function

6. Then select ok

math and trig category

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)

How to use ASIN function in excel

Examples of ASIN function in excel

Example 1:

How to use ASIN function in excel

You can see examples of ASIN function below:

 examples of ASIN function in excel
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

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)

Errors in ASIN function

ASIN related functions :

Leave a Reply

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