ASIN

Formulas / ASIN
Calculate the inverse sine of a number.
==ASIN(number)
  • number - the sine of the angle

Examples

  • =ASIN(0.5)

    The ASIN function can be used to calculate the arc sine of a number. In its simplest form it takes a value between -1 and 1 as a parameter. This formula calculates the arc sine of 0.5, and return 0.524 radians.

  • =ASIN(0.5)*180/PI()

    This formula will convert the result of the arc sine calculation from radians to degrees, and will return 30 degrees.

  • =DEGREES(ASIN(0.5))

    Alternatively, the DEGREES function can be used in conjunction with the ASIN function to achieve the same conversion from radians to degrees, and will also return 30 degrees.


Summary

The ASIN function calculates the arcsine of a number, returning an angle in radians between -pi/2 and pi/2. The angle must be between -1 and 1.

  • The ASIN function calculates the inverse sine (or arc-sine) of a number which must be between -1 and 1, and returns it in radians.
  • The ASIN function is the inverse of the SIN function.
  • The output of the ASIN function can be converted to degrees by multiplying by 180/PI() or by using the DEGREES function.

Frequently Asked Questions

What is the ASIN function?
The ASIN function returns the arcsine of an angle. The arcsine is also known as the inverse sine. The ASIN function returns the angle in radians, in the range from -pi/2 to pi/2.
How can I convert the arcsine to degrees?
The arcsine can be expressed in degrees by multiplying the output of the ASIN function by 180/PI(). Alternately, the DEGREES function can also be used to convert the arcsine to degrees.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV