Purpose
Return value
Syntax
=ASIN(number)
- number - The value to get the inverse sine of. The number must be between -1 and 1 inclusive.
Using the ASIN function
The ASIN function, also called arc-sine, returns the inverse sine of a value. The input number must be between -1 and 1, inclusive. Geometrically, given the ratio of a triangle’s opposite side over its hypotenuse, the function returns the angle of the triangle. For example, given a ratio of 0.5 the function returns the angle of 0.524 radians.
=ASIN(0.5) // Returns 0.524 radians
Convert Result to Degrees
To convert the result from radians to degrees, multiply the result by 180/ PI() or use the DEGREES function. For example, to convert the result of ASIN(0.5) to degrees, you can use either formula below:
=ASIN(0.5)*180/PI() // Returns 30 degrees
=DEGREES(ASIN(0.5)) // Returns 30 degrees
Explanation
The graph of ASIN visualizes the output of the function from -1 to 1. ASIN is the inverse of SIN. However, because SIN is a periodic function, the output of ASIN is limited to the range from -π/2 to π/2.
Notes
- ASIN is the inverse of SIN
- To convert the result from radians to degrees multiply by 180/PI() or use the DEGREES function.
Graph courtesy of wumbo.net
Purpose
Return value
Syntax
=ASINH(number)
- number - The number to get the inverse hyperbolic sine of.
Using the ASINH function
The Excel ASINH function returns the inverse hyperbolic sine of a number. Given one as input, the function returns 0.881373587 as output.
=ASINH(1) // returns 0.881373587
Explanation
The inverse hyperbolic sine returns the hyperbolic angle of the point on the unit hyperbola with a y -coordinate equal to the input. For example, given one as input representing the point on the unit hyperbola with a y -coordinate of one, the inverse hyperbolic sine returns the hyperbolic angle of 0.881373587.
=ASINH(1) // returns 0.881373587
Given an input of -2 corresponding to the point on the unit hyperbola with a y -coordinate of negative one, the inverse hyperbolic sine returns the hyperbolic angle of -1.443635475.
=ASINH(-2) // returns -1.443635475
The output of the inverse hyperbolic sine function is visualized in this plot:
Images courtesy of wumbo.net .
