How to use the 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(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)

Related functions

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 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.