=SQRT(x)

SQRT has one documented parameter; no optional parameters or defaults are described. The return type in KDE’s English function handbook is a floating-point value. The stable-KF6 handbook demonstrates SQRT(9) → 3 and a negative input as an error. The pinned Calligra 26.08.2 math registry separately confirms that SQRT is a shipped function name. Neither source establishes its original introduction date or proves execution on all platforms. Official syntax and errors · Pinned 26.08.2 source.

Locale: Enter = before the function name. SQRT alone needs no argument separator. Nested functions in the English KDE examples use semicolons (;) between their arguments and a period for decimal fractions; localized installations may use different punctuation. Confirm using the installed Insert → Function interface when transferring formulas from Excel or another locale. KDE formula-entry manual.

Start a blank sheet. Put Tile in A1, Area (square units) in B1, and Side length in C1. Enter the numeric data (not quoted strings):

Step 1: Type the labels and B2:B6 area numbers. Make sure B cells are stored as numbers.

Step 2: In C2 enter =SQRT(B2). Expected 3: 3² = 9. This matches the official literal control SQRT(9) → 3.

Step 3: Fill or re-enter formulas down C3:C6 with row numbers adjusted. Independently calculated expected results are 4, 5, 6, 0.

Step 4: Change B2 to 49 as a check; C2 is then expected to become 7 after recalculation. These are arithmetic predictions, not results observed in a running Calligra Sheets installation. Decimal results can be rounded on display without changing the underlying calculation.

For a right-angled coordinate calculation, enter B2=1, C2=2, D2=4, and E2=6 in an otherwise unused small sheet. Think of B/C as the first point (1,2) and D/E as the second point (4,6). In F2 use:

=SQRT(POWER(D2-B2;2)+POWER(E2-C2;2))

Expected result: 5. The horizontal difference is 3 and vertical difference is 4, so this takes SQRT(3²+4²) = SQRT(25) = 5. KDE’s POWER documentation separately specifies POWER(value;value). The single argument to SQRT is the entire sum; the semicolon separates the two arguments to each POWER call.

Protect a data-entry workflow: If G2 may contain negative values and you want to avoid a negative-domain error, use a condition before calculating:

=IF(G2<0;"Check negative input";SQRT(G2))

With G2 = −9, the intended result is the message Check negative input; with G2 = 9, the expected numeric result is 3. The existing IF guide covers the conditional function. This is a documentation-and-logic check, not a native test of evaluation behaviour.

• Negative inputs: KDE explicitly says SQRT(-9) is an error. Do not write an invented specific error token for every build; check the installed app’s displayed message.
• Not a complex square-root function: SQRT returns a real non-negative root for non-negative numeric inputs. KDE lists a separate IMSQRT for complex-number operations; do not assume it has the same input/output format.
• Zero is valid: SQRT(0) has expected result 0; it is not an error.
• Text values or blanks: The handbook specifies a numeric parameter but does not provide a universal result for every kind of text or blank input. Check imported values and avoid assuming that number-looking text is automatically numeric.
• Wrong operation: If calculating the side of a square, do not use =POWER(B2;2), which squares the area rather than taking the root.
• Displayed versus actual precision: Format settings may hide decimal places. Confirm the underlying numeric value before deciding the function rounded it.

Troubleshooting sequence: (1) Try the official control =SQRT(9); expected 3. (2) Verify the = sign and cell reference. (3) Check that the referenced number is ≥0 and numeric. (4) Check locale punctuation when nesting a multi-argument function. (5) If the cell appears blank or clipped, inspect column width and recalc settings per KDE’s Simple Sums guide. A precise error code or locale-dependent treatment needs native confirmation.

All three offer a SQRT-style real square-root calculation for non-negative numbers. The mathematical example 9 → 3 is portable; this does not prove identical error strings, text coercion, localized separators, or file-conversion accuracy. Excel commonly writes nested English formulas with commas; the KDE English handbook uses semicolons between arguments for functions such as POWER and IF. Confirm imports in the target application.

• IF in Calligra Sheets
• KDE SQRT function definition — return type, exact syntax, non-negative rule, and error example.
• KDE POWER function definition — composition used in distance example.
• Pinned Calligra 26.08.2 function registry — release-scoped registration.
• KDE Calligra release listing — 26.08.2, released 2026-10-08.

• Calligra Sheets — function documentation
• Pinned 26.08.2 source
• KDE formula-entry manual
• KDE’s POWER documentation

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

• No genuine Calligra Sheets screenshots are included; this guide does not use mock application images.