Knowledge base / Excel

ASIN in Excel: recover an angle, radians and degrees

I use a triangle example to explain input limits, radians, degrees and the ambiguity of recovering an angle from its sine.

Kajo RudzińskiPublished Updated 5 min read

A right triangle and an unmarked mechanical arc represent recovering an angle from a side ratio

To recover an angle from a sine value, use ASIN in Excel. The Polish function is also named ASIN. The mathematical term arcsine does not change the built-in function name: use ASIN in the worksheet.

I check three things: the argument’s range, the output unit, and whether the task needs the principal angle or every solution of an equation. Each can change the interpretation of an otherwise correctly calculated result.

Syntax and availability

In English Excel using a decimal point:

=ASIN(0.5)

The argument is a sine value rather than an angle in degrees. It must lie between -1 and 1 inclusive. The result is in radians between -pi/2 and pi/2. Microsoft’s ASIN documentation defines these rules and lists versions including Microsoft 365, Excel 2024, 2021, 2019 and 2016.

Polish regional settings commonly use =ASIN(0,5). The function name stays the same. Decimal separators depend on regional settings, so check them when copying an expression, together with the language of any other functions. ASIN itself takes one argument.

Radians and degrees

An input of 0.5 gives pi/6, approximately 0.523598776 radians. This corresponds to 30 degrees. The unconverted result is not a tiny angle measured in degrees; it uses a different unit. Displaying more decimal places does not convert it.

For degrees, use:

=DEGREES(ASIN(0.5))

The Polish equivalent is =STOPNIE(ASIN(0,5)). Microsoft’s DEGREES reference documents conversion from radians to degrees. Label the output column with its unit so the next reader does not have to infer it from the size of the values.

A small reference table

These synthetic inputs follow directly from sine values and the output range:

Sine value Radians Degrees
-1 -pi/2 -90
-0.5 -pi/6 -30
0 0 0
0.5 pi/6 30
1 pi/2 90

With inputs in A2:A6, enter =ASIN(A2) in B2 and =DEGREES(B2) in C2, then fill down. Column B contains radians and C contains degrees. Separate columns make the conversion visible without requiring a long nested expression for this simple example.

A right-triangle example

Consider a synthetic right triangle with an opposite side of length 1 and a hypotenuse of length 2, measured in the same unit. Their ratio is 0.5:

=DEGREES(ASIN(1/2))

The result corresponds to 30 degrees. The input is a dimensionless ratio of lengths. Do not supply the side length alone or the angle 30 as the argument. First establish which side is the hypotenuse and which acute angle determines the opposite side.

If the ratio exceeds one, check the data and units. In this model, the side opposite an acute angle cannot exceed the hypotenuse. The function cannot repair swapped sides. Using centimeters in the numerator and meters in the denominator also changes the input, although both columns may appear to contain ordinary numbers.

Two different arm positions reach the same height while a restricted arc indicates the principal-angle choice

ASIN selects a principal angle

A sine value does not identify one angle across the entire angle domain. Both 30 and 150 degrees have a sine of 0.5. ASIN selects the angle within the interval corresponding to -90 through 90 degrees, returned in radians. Applying an inverse sine therefore cannot recover every possible original angle.

If a task asks for every solution of a trigonometric equation, the function’s result is a starting point requiring further reasoning. The acute-angle assumption in a right triangle resolves that ambiguity. A full-rotation problem needs information about the relevant part of the rotation and the set of solutions requested.

Also distinguish an inverse function from a reciprocal value. ASIN(0.5) returns an angle, whereas 1/0.5 gives 2. These are different operations. “Inverse sine” means reversing the function on a specified interval rather than dividing one by a sine value.

Do not conceal out-of-range input

Neither 2 nor -2 can be the sine of a real angle. If such a value appears, inspect the formula, units, missingness and source interpretation. Replacing every failed result with zero would introduce a specific angle that could then be used in downstream calculations as if it were supported by the data.

If numerical precision makes a calculated ratio slightly exceed a boundary, any tolerance needs justification. Silently clipping every input into the interval from -1 to 1 can conceal a substantial source error. Keep records needing investigation distinguishable from valid observations exactly at a boundary.

Exercise and next step

Prepare the five inputs in the reference table and predict the sign of each result. Compare radians with degrees, then add an out-of-range argument and explain how it might arise in your process. Understanding those choices is more useful than memorizing the decimal approximation for one example.

For a broader foundation, read the article on mathematics for analysts. Leave a clear note in the workbook: the input is a sine value or an appropriate side ratio, the output has a specified unit, and the function selects an angle from its principal interval.

Key takeaways

Is the Polish function named ARCSIN?

The built-in inverse sine function is ASIN in Polish too. The earlier ARCSIN name in the Polish entry has been corrected.

Why do I get approximately 0.5236 instead of 30?

ASIN returns radians. Use DEGREES(ASIN(0.5)) for degrees.

Does ASIN recover every possible original angle?

No. It returns an angle from -pi/2 to pi/2; other angles can share the same sine.

AI was used in an automated way while working on this article. If you want to learn how to do it too, check out this project.

Kajo Rudziński

Newsletter KajoData

Let’s keep in touch.

I write about data analysis, learning and changing careers. My newsletter and the sign-up form are in Polish. If that works for you, I’d be glad to see you there.