# Learn =ASIN() Function – How to use with examples

Function: =ASIN()

The ASIN function in Excel returns the arcsine (inverse sine) of a given number in radians. The function can be used to find the angle whose sine value is equal to the given number.

### How to use ASIN() in excel:

To use the ASIN function, simply enter “=ASIN(number)” into a cell, where “number” is the value for which you want to find the arcsine. The function will return the result in radians.

#### To use the ASIN function in Excel, follow these steps:

1. Select the cell where you want to display the result.
2. Type the following formula into the formula bar: =ASIN(number), where “number” is the value for which you want to find the arcsine.
3. Press Enter to calculate the result.
4. The result will be displayed in the selected cell.

For example, if you want to find the arcsine of 0.5, you would enter “=ASIN(0.5)” into a cell. Excel will calculate the result in radians and display it in the cell.

Note that the input value for the ASIN function should be between -1 and 1. If the input value is outside this range, Excel will return the #NUM! error. Also, the result of the ASIN function is given in radians, which is a unit of measurement for angles. If you want to convert the result to degrees, you can use the DEGREES function.

### Examples ASIN() function in excel formulas:

1. =ASIN(0.5) returns 0.523598776 radians (which is approximately 30 degrees).
2. =ASIN(-0.5) returns -0.523598776 radians (which is approximately -30 degrees).
3. =ASIN(1) returns 1.570796327 radians (which is approximately 90 degrees).
4. =ASIN(0) returns 0 radians (since the sine of 0 is also 0).
5. =ASIN(2) returns #NUM! (since the sine of any value is always between -1 and 1).

### List of similar functions:

1. SIN: returns the sine of an angle in radians.
2. COS: returns the cosine of an angle in radians.
3. TAN: returns the tangent of an angle in radians.
4. ACOS: returns the arccosine (inverse cosine) of a given number in radians.
5. ATAN: returns the arctangent (inverse tangent) of a given number in radians.

### FAQs about use of ASIN function in Excel

What is the range of input values for the ASIN function?

The input values for the ASIN function must be between -1 and 1, inclusive.

What does the #NUM! error mean in the ASIN function?

The #NUM! error is returned when the input value for the ASIN function is outside the range of -1 to 1.

Can the ASIN function be used with non-numeric input?

No, the ASIN function only works with numeric input values.

What is the difference between the SIN and ASIN functions?

The SIN function returns the sine of an angle, while the ASIN function returns the angle whose sine is equal to a given value

What is the unit of measurement for the output of the ASIN function?

The ASIN function returns the result in radians, which is a unit of measurement for angles.

### Learn MS Excel Functions

#### esyExcel

Gavesh S. is the founder and owner of EsyExcel.com. He has been a Microsoft Excel Expert since early 2012. With experience explained thousand of queries for companies including Microsoft and top other financial institutions. Theres is most uses of Business Analysis, People Management, Automation, Performance Reporting, Strategic Analysis, Project Management, Managing Programs, Account Management etc.  In 2021 he found EsyExcel.com to share his experiences with other who’s is looking to learn MS Excel. He is currently working on a book about working in the Learn Excel, expanding his skill set beyond the Excel Learning niche.