ONLYOFFICE ASIN Function: Inverse Sine, Degrees, Examples and Limits

In a blank cell, enter =ROUND(DEGREES(ASIN(0.5)),6) to find the inverse-sine principal angle. Its independently expected answer is 30 degrees, not 0.5 radians. =ROUND(ASIN(0.5),6) instead has an expected value of 0.523599 radians. These results are mathematical predictions, not observations from an ONLYOFFICE installation.

Use ASIN when you know the sine ratio of an angle and need the principal inverse-sine result—for example, a triangle’s opposite side divided by its hypotenuse, provided the hypotenuse is nonzero and the ratio is between −1 and +1. The official ONLYOFFICE definition calls this function the arcsine of a numeric input and explicitly limits the input to −1 through 1, inclusive. By mathematical convention, the principal result lies between −π/2 and π/2 radians (−90° through 90°). The vendor’s short ASIN reference itself does not give a full numerical edge-case or version matrix.

=ASIN(number)

Exactly what is documented: the one required numeric argument is described in the ONLYOFFICE ASIN Help Center entry (accessed 2026-10-13 UTC). No optional arguments or defaults are specified for this function. Numbers may be directly typed or supplied by referenced cells. The documentation does not provide a full table of behaviour for blank references, quoted numeric strings, Booleans, arrays, worksheet error propagation or a first-introduced version; those areas require native checking. ASIN takes a sine ratio, not degrees or radians as its argument.

The named function is present in the current official Spreadsheet Editor function catalogue and the function-specific article, both checked on 2026-10-13 UTC. This is documentation confirmation, not a claim of successful calculation in any installed build. The function article is not tagged with a minimum Docs web, self-hosted Docs, or Desktop Editors release. The separate Docs changelog and Desktop Editors changelog were consulted, but no first-supported-version or complete cross-platform parity statement for ASIN was established. No native Desktop/web application or screenshot testing was available.

These formulas show the English-language function name, decimal point and comma delimiter (where more than one argument exists). ONLYOFFICE’s Advanced Settings has distinct Formula Language and Region selectors and configurable decimal/thousands separators; it does not validate any particular translated name or argument separator in this research. Check the Formula Language setting and tooltips before pasting formulas on another locale or a different editor release. The official function entry guide explains the Home and Formula insert menus, Shift+F3, equal sign, parentheses and comma-separated arguments for its English examples.

Evidence labels throughout: A statement called official-documentation checked is drawn from the linked ONLYOFFICE page; a displayed number called independently calculated was computed from the mathematical definition using Python’s math library and then rounded for readability; native ONLYOFFICE observed results: none. Correct-looking expected values do not prove the installed program has calculated them.

1. Open a new workbook. Enter Sine input in A1, Raw ASIN (radians) in B1 and Principal angle (degrees) in C1.
2. Enter the numeric values shown in column A below, one per row. Values approximating √2/2 and √3/2 are already rounded to twelve decimals; type those exact decimals, not the mathematical radical.
3. Type =ASIN(A2) in B2; type =ROUND(DEGREES(B2),6) in C2. Then drag/fill both formulas through row 10. Column B is in radians, column C should show the six-decimal degree expectation below.
4. Compare the output with the independent expectations, checking Formula Language, numeric input, and rounding if different. The table shows the formula in C’s computationally equivalent fully expanded form; you may enter =ROUND(DEGREES(ASIN(A2)),6) directly instead.

Independent check: raw ASIN values were evaluated with Python math.asin() on the exact entered decimal strings, then multiplied by 180/π for the degree expectation. ROUND rounds the numeric result; exact binary outputs and edge-case text coercion remain native-unverified.

Height and diagonal length

Suppose a support rises 3 m over a diagonal of 5 m. Put 3 in D2 and 5 in E2, then enter =ROUND(DEGREES(ASIN(D2/E2)),6) in F2. The expected principal angle is 36.869898°. For a valid right triangle with positive lengths, check 0 ≤ D2/E2 ≤ 1; if the diagonal is zero or the rise exceeds the diagonal, the model is invalid. The formula itself does not check physical plausibility.

Arc length using a principal angle

If the sine of a central angle is 0.6, the principal central angle is ASIN(0.6) radians. With radius 10 units, =ROUND(10*ASIN(0.6),6) has expected arc length 6.435011 units (arc length = radius × angle in radians). This is only the arc for the principal angle, not every angle with sine 0.6. An alternate supplementary angle gives a different arc length.

Inverse sine cannot recover every original angle

The sine of 150° equals the sine of 30°. Consequently, =ROUND(DEGREES(ASIN(SIN(RADIANS(150)))),6) has mathematical principal-angle expectation 30, not 150. Recovering a full-circle direction requires additional quadrant information; do not use ASIN alone as a substitute for a quadrant-aware coordinate formula.

Rounding a theoretically valid ratio near 1

Arithmetic near a boundary can theoretically produce 1.000000000001, outside ASIN’s documented input range. Before deciding whether to use a clamp such as MIN(1,MAX(-1,ratio)), inspect the model and tolerance. Clamping an actually invalid ratio can conceal bad data. The precise ONLYOFFICE error code for such inputs has not been observed.

• Outside the domain: values less than −1 or greater than 1 violate the official argument definition. The real-number inverse sine is undefined there; we do not assert a specific ONLYOFFICE error code without application testing.
• Argument confusion: ASIN(30) is not “the sine of 30°”. ASIN expects a sine value, not a degree angle; use SIN(RADIANS(30)) to calculate the ratio first if needed, then inverse it.
• Unexpected 0.523599 instead of 30: the first figure is a radian angle; use DEGREES(ASIN(...)) to present degrees.
• Lost direction: ASIN gives a principal result, so 150° and 30° can collapse to the same answer after applying SIN then ASIN.
• Tiny positive/negative zero or rounding noise: display and floating-point precision can vary; compare using a small tolerance, not bit-for-bit identity. Mathematical prediction is not observed native output.
• Missing formula or literal string instead of result: ensure the cell begins with =, the value in A2 is a number, and Formula Language and decimal separators match the entered syntax.
• Blank, text, Boolean, array and referenced error values: the short official page does not fully specify coercion and propagation; test the installed edition before relying on an error-code matrix.

Microsoft documents Excel ASIN(number) with a −1…1 numeric argument and inverse-sine result in radians. That is separate Excel documentation, not proof that ONLYOFFICE and Excel share coercion, floating-point precision, localized spellings, release coverage, or error strings. Google Sheets, LibreOffice and other spreadsheet programs were not natively compared in this run. If migrating a workbook, check formula names, argument/decimal separators and critical boundary cases in both the source and destination application before relying on identical results.

• ONLYOFFICE ASIN function reference — required argument and official range.
• ONLYOFFICE DEGREES function — radians to degrees.
• ONLYOFFICE RADIANS function — degrees to radians.
• ONLYOFFICE ATAN function — ratio of tangent, a distinct inverse function.
• ONLYOFFICE ATAN2 function — coordinates, x then y, used for quadrant-sensitive directions.

1. Function existence, ASIN(number) and inclusive −1…1 input constraint: ONLYOFFICE Help Center ASIN, documentation checked on 2026-10-13 UTC. Does not establish minimum supported release or exact error codes.
2. Radian-to-degree formula DEGREES(angle): ONLYOFFICE DEGREES, documentation checked 2026-10-13 UTC. Formula examples’ angles are independent mathematical expectations.
3. Angle conversion RADIANS(angle): ONLYOFFICE RADIANS, documentation checked 2026-10-13 UTC.
4. Inserting and editing functions: ONLYOFFICE insert function guide, checked 2026-10-13 UTC.
5. Language, region, separators: ONLYOFFICE Advanced Settings, checked 2026-10-13 UTC.
6. Distinct release paths without an established first-supported build: Docs changelog and Desktop changelog, checked 2026-10-13 UTC.
7. Limited cross-software comparison only: Microsoft Excel ASIN, checked 2026-10-13 UTC; this is not ONLYOFFICE execution evidence.

Verification limits: Native Desktop/web execution, localized parsing, exact runtime errors and historical release support remain untested.