Exceljet

Quick, clean, and to the point

Excel ASIN Function

Excel ASIN function
Summary 

The Excel ASIN function returns the inverse sine of a number.

Purpose 
Return the inverse sine of a value in radians.
Return value 
Angle in Radians
Syntax 
=ASIN (number)
Arguments 
  • number - The value to get the inverse sine of. The number must be between -1 and 1 inclusive.
Version 
Usage notes 

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.

=ASIN(0.5) // Returns 0.524 radians

Convert Result to Degrees

To convert the result from radians to degrees, multiply the result by 180/PI() or use the DEGREES function. For example, to convert the result of ASIN(0.5) to degrees, you can use either formula below:

=ASIN(0.5)*180/PI() // Returns 30 degrees
=DEGREES(ASIN(0.5)) // Returns 30 degrees

Explanation

Graph of ASIN Function

The graph of ASIN visualizes the output of the function from -1 to 1. ASIN is the inverse of SIN. However, because SIN is a periodic function, the output of ASIN is limited to the range from -π/2 to π/2.

Notes

  • ASIN is the inverse of SIN
  • To convert the result from radians to degrees multiply by 180/PI() or use the DEGREES function.

Graph courtesy of wumbo.net

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.

Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Charts video training course
Video training for Excel Tables
Dynamic Array Formulas