Formulas and Functions

ASIN
The ASIN function returns the arcsine (the inverse sine) of a number.
ASIN(num)
num: A number value. num must be greater than or equal to –1 and less than or equal to 1.
Notes
The ASIN function takes a sine and returns the corresponding angle. The result is expressed in radians, in the range –pi/2 to +pi/2. To see the resulting angle in degrees instead of radians, wrap this function in the DEGREES function; that is, =DEGREES(ASIN(num)).
Examples |
---|
=ASIN(0.84114709848079) returns approximately 0.999400825621613, the radian measure (approximately 57.3 degrees) of the angle that has a sine of 0.8411470984807897. =DEGREES(ASIN(0.5)) returns 30, the degree measure of the angle that has a sine of 0.5. |