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

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.