Exceljet

Quick, clean, and to the point

Excel ASIN Function

Excel ASIN function
Summary 

The Excel ASIN function returns the arcsin of a number.

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 

ARCSIN expects an input between -1 and 1, where the input is a ratio of the opposite-side over the hypotenuse of a right triangle.

ASIN Right-Triangle
θ = ASIN(opposite/adjacent) // Where θ is the angle

Inverse

ARCSIN( ratio) is the inverse of SIN(angle)

= angle = ARCSIN( SIN(angle))

Return Type

To convert from radians to degrees multiply by 180/pi() or use the DEGREES function.

= angle * 180/PI()
= DEGREES( angle)

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.