Exceljet

Quick, clean, and to the point

Excel ASIN Function

Excel ASIN function
Summary 

The Excel ASIN function returns the angle of a right triangle given the ratio of its adjacent side over its hypotenuse side. ASIN is the inverse of the SIN function.

Purpose 
Get the angle of a triangle.
Return value 
Angle in Radians
Syntax 
=ASIN (number)
Arguments 
  • number - The ratio of the opposite-side over the hypotenuse of a right-triangle.
Usage notes 

The ASIN function returns the angle of a right triangle given the ratio of the adjacent side over the hypotenuse side. The input number must be between -1 and 1. For example, if the length of a right-triangle's adjacent side is 1 and the length of its hypotenuse is 2 to find the angle of the triangle the formula is:

=ACOS(1/2) // Returns 0.524 radians

To convert the result from radians to degrees, the formula is:

=ACOS(1/2)*180/PI() // Returns 30 degrees
Related functions 
Excel SIN function
Excel SIN Function

The Excel SIN function returns the sine of angle given in radians. To supply an angle to SIN in degrees, multiply the angle by PI()/180 or use the RADIANS function to convert to radians.

Excel ACOS function
Excel ACOS Function

The ACOS function returns the angle of a right triangle given the ratio of the adjacent side over the hypotenuse side. ACOS is the inverse function of the COS function.

Excel ATAN function
Excel ATAN Function

The Excel ATAN function returns the arctangent of a number. In geometric terms, the function returns the angle of a right-triangle given the ratio of its opposite side over its adjacent side. The ATAN function is the inverse of the TAN function...

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.

500 Formula Examples, thoughtfully explained.