ASINH Function in ONLYOFFICE Spreadsheet Editor: Inverse Hyperbolic Sine, Signed Measurements and Examples

ASINH returns the inverse hyperbolic sine of a real number. Unlike the regular inverse sine ASIN, its real-number input is not restricted to the interval from -1 to 1. The hyperbolic sine is strictly increasing, so every real input has exactly one real inverse. ASINH is an odd function: asinh(-x) = -asinh(x).

The defining mathematical identity is asinh(x) = ln(x + √(x² + 1)). This is a mathematical equation, not a claim about the vendor’s internal implementation or floating-point algorithm. This guide is about a real-number mathematical function, not formatting, a formula-name alias, or an add-on.

=ASINH(number)

Documented input requirement: All finite real input values are mathematically permitted. The brief vendor reference imposes no lower or upper bound. No optional argument or second parameter appears in ONLYOFFICE’s official ASINH entry, accessed 2026-10-13. The function name is uppercase in English; a formula begins with = when typed into a worksheet. This syntax and the number of arguments are vendor-documented; the numerical examples below are separate mathematical calculations.

The official Insert Functions guide explains that users can enter the formula manually, search for a function under Formulas/Math and Trigonometry, or open the Insert Function dialog (including Shift+F3). Its generic examples describe argument separators as commas, but ASINH has only one argument, so no separator appears in this guide’s primary formulas.

1. Open a blank spreadsheet and, for reproducibility, use English formula language and a decimal-point regional setting. This page does not assume a user has any existing data.
2. In A1 enter Input; in B1 enter ASINH output; in C1 enter Independent expected output.
3. Enter the numeric A2:A13 values exactly as shown in the following table (not text strings). All twelve are within the function’s documented real-number input domain.
4. In B2 enter =ASINH(A2) and press Enter, then fill/copy B2 down to B13. Each relative A-reference should follow its corresponding input row.
5. The values in the last column were precomputed mathematically. Use them to compare results after you open the workbook in your own Desktop or web editor. Different display formats and floating-point rounding may change visible final digits. This five-step procedure is a reproducible manual test plan, not a test reported as executed here.

The expected values use the mathematical function asinh from Python’s standard library, rounded for display to at most ten decimals; equality at more decimals and vendor-specific handling have not been measured. To confirm the copied range refers to the correct row, change A3 temporarily to another valid number, observe B3 in a native test, then restore it.

• =ASINH(-10) → -2.9982229503 (independent mathematical expectation; not observed in ONLYOFFICE).
• =ASINH(-1) → -0.881373587 (independent mathematical expectation; not observed in ONLYOFFICE).
• =ASINH(0.1) → 0.0998340789 (independent mathematical expectation; not observed in ONLYOFFICE).
• =ASINH(2) → 1.4436354752 (independent mathematical expectation; not observed in ONLYOFFICE).

When entering a numeric literal, use parentheses and the leading =. In =ASINH(A2), A2 is a cell reference; number in the vendor syntax is a placeholder, not the word to type into a formula.

Suppose column A records signed changes relative to a baseline. ASINH compresses extreme values smoothly while keeping zero at zero and preserving the sign. This is a mathematical transformation, not a universally justified statistical model; choose the scaling unit before applying it.

Procedure: Put the relevant inputs in A2:A13, enter =ASINH(A2) in B2 and copy down. Keep the original inputs intact for auditing; use a separate output column. Change only the business meaning of the inputs, not the mathematical domain or syntax. The expected results remain those independently computed in the worksheet table.

1. Signed compression

Put the signed measurement -10 in A2. =ASINH(A2) has an expected mathematical value of about -2.99822295, whereas the original input is -10. For a dimensionful measurement (for example, kilograms), divide by a stated scale before transforming.

2. Scaled, interpretable transform

Enter -20 in A2 and a positive reference scale 10 in D2. =ASINH(A2/$D$2) corresponds to asinh(-2), approximately -1.44363548. Fixing D2 with $ allows a single scale to apply when copied down. The mathematical expectation is calculated independently.

3. Invert the transform

For x=2 in A2, =SINH(ASINH(A2)) should mathematically give 2 within rounding. The official SINH and ASINH names and signatures are documented, but the nested expression has not been executed in ONLYOFFICE.

4. Independent identity for a positive x

For x=2, =LN(A2+SQRT(A2*A2+1)) has the mathematical expectation 1.44363548. This is a cross-check derived from mathematics, not a universally stable numerical implementation. Negative x with large magnitude can cause subtraction/cancellation; prefer the direct ASINH function.

5. Round for reporting

For x=2, =ROUND(ASINH(A2),4) should display 1.4436 mathematically. ROUND is separately documented by ONLYOFFICE; rounding is for presentation and should not replace storing underlying values.

For nested examples, refer to the relevant source cells stated in each example. Arithmetic equalities are mathematical expectations, and should be tested in the user’s particular ONLYOFFICE edition before relying on edition-specific output.

Missing arguments: =ASINH() omits the only required argument. Do not assume a specific error label from Excel or another spreadsheet: the short ONLYOFFICE reference identifies the required argument but does not enumerate exact product error messages across releases. All finite real numbers are in the mathematical domain; nonnumeric inputs and missing arguments still require native validation. No screenshots were captured.

• Vendor-confirmed syntax: the function name, number argument, documented domain, and category come from the official ASINH reference reviewed on 2026-10-13.
• Locale: ONLYOFFICE’s Advanced Settings specifies a configurable Formula Language and configurable regional decimal and thousands separators. Choose English if using the exact formulas in this tutorial. A German, French, or other localized function spelling and decimal-input syntax are not independently tested.
• Formula entry: the Insert Functions guide documents entering = and a named function, as well as the Insert Function wizard. The particular shortcuts or visual placement can vary by edition.
• Web and Desktop: the vendor maintains a unified, unversioned function page; existence of the reference establishes documentation for ONLYOFFICE Spreadsheet Editor but does not establish first-supported Desktop/web versions, rollout order, platform parity or exact historical behavior. The Docs 10.0 announcement dated October 2026 does not independently prove this function was newly added then.
• Compatibility with other spreadsheets: no Excel, Google Sheets or LibreOffice workbook execution or file interchange test was performed. The formulas follow standard mathematics, but vendor behavior, error codes, names and localized separators must not be inferred from other products.
• Verification levels: source syntax/domain = official documentation check; displayed numeric values and identities = independent mathematical calculations, not observations; native ONLYOFFICE execution, screenshot evidence, exact error codes, localized behavior and cross-product output = not performed.

• SINH function — related vendor reference, checked 2026-10-13.
• LN function — related vendor reference, checked 2026-10-13.
• SQRT function — related vendor reference, checked 2026-10-13.
• ROUND function — related vendor reference, checked 2026-10-13.
• ONLYOFFICE Insert Functions — vendor instructions for function search and entering formulas (checked 2026-10-13).
• ONLYOFFICE Advanced Settings — Formula Language, region, and separators (checked 2026-10-13).

Reference access date: 2026-10-13. Source-page version: unversioned ONLYOFFICE Help Center pages (the vendor pages do not provide a first-support release). Do not claim that a particular historical release provides identical evaluation until native version-by-version tests exist.