Use =SQRT(number) to find the nonnegative square root of a nonnegative number. =SQRT(144) has an expected result of 12. A negative argument is documented by ONLYOFFICE to return #NUM!.

Calculate nonnegative square roots and check negative-input errors before measuring distances. The examples are designed for a spreadsheet you can create yourself, so no sample download or proprietary data is needed. Only the function’s explicitly documented behaviour is attributed to ONLYOFFICE; sample outputs are described as expected, not observations.

=SQRT(number)

This is the full one-argument syntax from ONLYOFFICE’s SQRT reference. The same reference explicitly states that a negative number returns #NUM!. The term square root here refers to the nonnegative real root, not complex-number handling.

Documentation scope: The signature and core purpose above are documented by the unversioned English ONLYOFFICE Docs Spreadsheet Editor function reference, checked 11 October 2026 (UTC). That confirms help-site documentation, not a universal guarantee that the function behaves identically in every installed release, browser integration, mobile app, or Desktop Editors build. The referenced Docs release history and distinct Desktop Editors release history were checked; neither establishes a first-supported version for this function. First-supported Docs/Desktop/mobile versions: UNKNOWN; target-version native compatibility: NOT TESTED.

In English examples, formulas begin with =, function arguments are enclosed in parentheses, and multi-argument functions use a comma (see ONLYOFFICE’s formula-entry instructions). Under File → Advanced Settings, formula language and region can be changed; the official regional settings instructions discuss locale and decimal/thousands separators. Do not blindly substitute semicolons or localized function names: confirm the target editor’s language, regional settings and argument separator. All sample decimals below use a dot and English function names.

How to try the examples

1. Create a new blank worksheet. Enter the input table below into the specified cell addresses; enter numeric values as numbers rather than quoted strings.
2. Enter each formula in its listed output cell, beginning with =. Choose Formula → Function to use the arguments wizard if necessary.
3. Compare with the values marked independently calculated expected results, not observed ONLYOFFICE outputs. Set the output cells to General or Number format as appropriate.
4. Keep original input values unchanged so the formulas can be independently checked, and log discrepancies against the installed software version and locale before relying on the result.

Enter =SQRT(A2) in B2 and copy to B7. The ≈ sign in the table indicates display rounding by this article, not a claim about ONLYOFFICE’s default number of visible digits. The error row is taken from vendor documentation, not from a native execution.

Calculate a straight-line distance from two coordinate pairs

In empty cells, put the following numeric coordinates:

Then enter:

=SQRT(POWER(H2-F2,2)+POWER(I2-G2,2))

The expected result is 5: horizontal displacement 3, vertical displacement 4, squared sum 9+16=25, and SQRT(25)=5. POWER is also independently documented by ONLYOFFICE. This calculation assumes both axes use the same length unit and a flat Euclidean plane; it is not geographic distance on Earth’s surface.

For a cleaner display when checking root 2, =ROUND(SQRT(A3),4) has expected result 1.4142. This adds the documented ROUND function; using a shorter display format without rounding does not necessarily change the stored numeric value.

Data-quality gate: =IF(A6<0,"Check input",SQRT(A6)) is designed to return Check input when A6 is -9. Check the input rather than applying ABS automatically: SQRT(ABS(-9))=3 answers a different problem and can disguise a corrupt measurement.

Troubleshooting: check that the input cell contains a positive number, not a currency string; verify the formula starts with =, and inspect the actual cell precision. If you get a different error from the one documented for a negative number, record the editor edition/version, the exact formula and input type.

Excel’s SQRT documentation uses SQRT(number) and explicitly documents #NUM! for negative input, consistent with the ONLYOFFICE SQRT reference. LibreOffice Calc documents corresponding mathematical functions. No documented difference is established here for nonnegative numeric inputs, but this does not certify identical rounding or coercion across builds. The English argument-separator convention is irrelevant to one-argument SQRT but matters for combining ROUND, POWER or IF in multi-argument formulas.

• ONLYOFFICE POWER — squares and general exponents.
• ONLYOFFICE ROUND — display a controlled decimal precision.
• ONLYOFFICE IF — check a negative input before taking a real root.
• ONLYOFFICE ABS — optional magnitude conversion only when the mathematics calls for it.

• ONLYOFFICE Spreadsheet Editor — function documentation
• Docs release history
• Desktop Editors release history
• ONLYOFFICE’s formula-entry instructions
• official regional settings instructions
• POWER
• documented ROUND function

Verification status: Official documentation checked; example outcomes were independently reasoned or arithmetically checked where applicable. Not executed in ONLYOFFICE Spreadsheet Editor.

• No genuine ONLYOFFICE Spreadsheet Editor screenshots are included; this guide does not use mock application images.