Quick Navigation
ASIN Function
Summary
The Excel ASIN function returns the arcsine (inverse sine) of a number, expressed in radians. It calculates the angle whose sine equals the given number, with results ranging from -π/2 to π/2. Perfect for trigonometric calculations and engineering applications.
Syntax
ASIN(number)Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| number | Number |
Yes | The sine value of the angle you want to find. Must be between -1 and 1. |
Using the ASIN Function
ASIN is a key trigonometric function used in mathematics, physics, and engineering to find angles from sine ratios. Use it when you need the inverse sine operation in radians. Combine with DEGREES function or 180/PI() multiplication for degree results.
Common ASIN Examples
Basic ASIN Calculation
=ASIN(-0.5)Returns the arcsine of -0.5 in radians (approximately -0.5236, or -π/6 radians).
Convert to Degrees
=DEGREES(ASIN(-0.5))Converts arcsine of -0.5 from radians to degrees, returning -30°.
Using PI for Conversion
=ASIN(-0.5)*180/PI()Arcsine of -0.5 converted to degrees using PI function, returns -30°.
Frequently Asked Questions
Common Errors and Solutions
#NUM!
Cause: Input number is less than -1 or greater than 1
Solution: Ensure input value is between -1 and 1 inclusive
#VALUE!
Cause: Input is not a valid number (text, empty cell, etc.)
Solution: Provide a numeric value between -1 and 1
Notes
- Output range: -π/2 (-1.5708) to π/2 (1.5708)
- ASIN(-x) = -ASIN(x)
- Common in physics for pendulum angles, wave analysis
- Pair with SIN function for angle verification
Compatibility
Available in: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Microsoft 365
Not available in:
Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2007+