How to use the Excel ASIN function

The ASIN function, also called arc-sine, returns the inverse sine of a value. The input number must be between -1 and 1, inclusive. Geometrically, given the ratio of a triangle’s opposite side over its hypotenuse, the function returns the angle of the triangle. For example, given a ratio of 0.5 the function returns the angle of 0.524 radians.

Syntax: =ASIN(number)

The ASIN function syntax has the following arguments:

  • number – The value to get the inverse sine of. The number must be between -1 and 1 inclusive.

Example: Let’s look at some Excel ASIN function examples and explore how to use the ASIN function as a worksheet function in Microsoft Excel:

Excel ASIN function - How to use the Excel ASIN function

Syntax:  =ASIN(A2)

Result:

Excel ASIN function 1 - How to use the Excel ASIN function

Based on the Excel spreadsheet above, the following ASIN examples would return:

Syntax: =ASIN(A3)
Result: -0.523598776

Syntax: =ASIN(A4)
Result: -0.747762635

Syntax: =ASIN(A5)
Result: 0

Syntax: =ASIN(A6)
Result: 0.747762635

Syntax: =ASIN(A7)
Result: 0.523598776

Syntax: =ASIN(A8)
Result: 1.570796327

Add a Comment

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