ASIN returns the arcsine of a number, giving the angle whose sine is that number, in radians. It is the inverse of the SIN function and accepts values from -1 to 1.
=ASIN(number)What does ASIN do?
The ASIN function in Excel calculates the arcsine of a number. In plain terms, if you know the sine of an angle, ASIN tells you what that angle is. The result is always in radians, between -π/2 and π/2 (roughly -1.5708 to 1.5708).
This matters because many real-world calculations start with a ratio, such as opposite side divided by hypotenuse, and you need the angle itself. Engineers, analysts, and students use ASIN to reverse sine calculations without manual trigonometry tables.
Imagine you are checking the slope of a ramp for accessibility compliance. You measure the rise and the length, divide to get a sine value, then use ASIN to find the angle in radians. From there you can convert to degrees and compare against the required limit.
When to use ASIN
- Finding an angle from a known sine ratio in geometry or physics homework.
- Checking ramp or roof slope angles from rise and run measurements.
- Converting signal ratios into phase angles in basic engineering work.
- Reverse-engineering angles from survey or navigation data.
- Teaching the relationship between sine and arcsine in a spreadsheet.
ASIN syntax
=ASIN(number)| Argument | Required? | What to enter |
|---|---|---|
number | Required | The sine value of the angle you want. It must be between -1 and 1 inclusive. For example, 0.5 returns the angle whose sine is 0.5. |
What it returns: A number in radians between -π/2 and π/2 (about -1.5708 to 1.5708) representing the angle whose sine is the input value.
ASIN examples
1 Basic arcsine of a simple ratio
This example shows the simplest use: a single sine value in a table. The goal is to see what angle produces that sine. The formula =ASIN(B2) reads the value in B2 and returns the angle in radians. Because 0.5 is a familiar sine value, the result is about 0.5236 radians, or 30 degrees if converted.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Item | Sine Value | |||
| 2 | Ratio 1 | 0.5 | 0.5235987756 | ||
| 3 | Ratio 2 | 0.7071 | |||
| 4 | Ratio 3 | 0.866 | |||
| 5 |
2 Convert a sine ratio to degrees
ASIN returns radians, but many people think in degrees. This example takes a sine value from the table and converts the result using DEGREES. The formula =DEGREES(ASIN(B3)) first finds the arcsine of 0.7071, then converts it to degrees. The result is approximately 45 degrees, a common angle in right triangles.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Triangle | Opposite/Hypotenuse | |||
| 2 | T1 | 0.5 | 44.99945053 | ||
| 3 | T2 | 0.7071 | |||
| 4 | T3 | 0.866 | |||
| 5 |
3 Find the angle of a ramp from rise and length
Here the sine value is not given directly; it is calculated from rise divided by length. The goal is to find the ramp angle in radians. The formula =ASIN(B2/C2) divides the rise in B2 by the length in C2, then applies ASIN. For a rise of 1 and length of 2, the sine is 0.5, so the angle is about 0.5236 radians.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Ramp | Rise (m) | Length (m) | |||
| 2 | Ramp A | 1 | 2 | 0.5235987756 | ||
| 3 | Ramp B | 1.5 | 3 | |||
| 4 | Ramp C | 0.8 | 2 | |||
| 5 |
4 Check roof slope compliance in degrees
A building code may limit roof slope to a certain angle. This example calculates the slope angle in degrees from rise and run. The formula =DEGREES(ASIN(B2/C2)) computes the sine ratio, finds the arcsine in radians, and converts to degrees. For a rise of 3 and run of 5, the sine is 0.6, giving about 36.87 degrees.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Roof | Rise | Run | |||
| 2 | Roof 1 | 3 | 5 | 36.86989765 | ||
| 3 | Roof 2 | 4 | 5 | |||
| 4 | Roof 3 | 2 | 5 | |||
| 5 |
5 Phase angle from a signal ratio
In basic signal work, a ratio between -1 and 1 can represent a sine value, and the phase angle is its arcsine. This example uses a table of ratios and returns the phase angle in radians. The formula =ASIN(B2) reads the ratio in B2 and returns the angle. A ratio of 0.25 gives about 0.2527 radians.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Signal | Ratio | |||
| 2 | S1 | 0.25 | 0.2526802551 | ||
| 3 | S2 | 0.5 | |||
| 4 | S3 | 0.75 | |||
| 5 |
Common ASIN errors and how to fix them
| Error | Why it happens | How to fix it |
|---|---|---|
| #NUM! | The number argument is outside the range -1 to 1, so no real angle has that sine. | Check that the input is a valid sine value between -1 and 1. If it comes from a division, make sure the numerator is not larger than the denominator. |
| #VALUE! | The argument is text or a blank cell that cannot be treated as a number. | Enter a numeric value or reference a cell that contains a number. Remove spaces or text from the cell. |
| #NAME? | The function name is misspelled, such as ASINN or ASIN with a space. | Type =ASIN( exactly. Excel usually suggests the correct function as you type. |
| Wrong-looking small number | ASIN returns radians, but you expected degrees. | Wrap the formula in DEGREES, for example =DEGREES(ASIN(0.5)), to get the angle in degrees. |
Tips for using ASIN
- Remember that ASIN returns radians; use DEGREES when you need a familiar angle measurement.
- Keep input values between -1 and 1 to avoid #NUM! errors.
- Use ASIN when you already have a sine ratio; use ATAN2 when you have opposite and adjacent sides.
- Format the result cell to show enough decimal places so small angle differences are visible.
- Combine ASIN with ROUND to present clean angle values in reports.
Frequently asked questions
What does ASIN return in Excel?
ASIN returns the arcsine of a number, which is the angle in radians whose sine is that number. The result is between -π/2 and π/2.
Why does ASIN give a small decimal instead of degrees?
Excel trigonometric functions work in radians by default. To get degrees, wrap the formula in DEGREES, for example =DEGREES(ASIN(0.5)).
What happens if I use a number greater than 1 in ASIN?
Excel returns #NUM! because no real angle has a sine greater than 1. Make sure your input is between -1 and 1.
Is ASIN the same as 1/SIN?
No. 1/SIN gives the cosecant, not the angle. ASIN is the inverse sine function that returns an angle.
Related functions
Every example on this page was recalculated by SheetSkill’s spreadsheet engine. ASIN reference