=ASIN(number)
=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.
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.