=POWER(value;value)

Order matters: POWER(2;3) is 8, while POWER(3;2) is 9. KDE documents two numeric arguments and no optional parameter or default. Its stable-KF6 handbook gives POWER(1.2;3.4) ≈ 1.8572 and POWER(2;3) = 8. The pinned 26.08.2 function registry contains a POWER registration using the func_pow implementation. This confirms availability in that release’s source, not cross-platform runtime execution. Handbook · Release code.

The handbook also lists POW as an equivalent documented function name. The 26.08.2 registry lists POW and POWER as separate registered primary names pointing to the same implementation, not as one of its 102 explicit aliases; for editorial coverage, a related name alone is not enough to justify a duplicate tutorial. Keep both names visible for readers without silently treating POW as a separately completed page.

Locale note: The English Calligra manual uses a semicolon between two arguments, and a decimal period in examples. Other regional settings may use different punctuation. English Excel examples commonly use commas. Use the installed function picker to verify separators rather than pasting another application’s punctuation. KDE formula-entry guide.

On a new sheet label B1 Base, C1 Exponent, D1 Result. Type B and C as numbers; enter a formula in D2 and adapt each row reference.

Step 1: Enter numbers in B2:C6, preserving a negative sign in C5 and decimal 0.5 in C6.

Step 2: In D2 enter =POWER(B2;C2). Expected 8, the same numeric example KDE documents. Fill the formula down through D6, checking the row numbers.

Step 3: Independently check D3 = 5² = 25, D4 = 10⁰ = 1, D5 = 4⁻¹ = 1/4 = 0.25, and D6 = 9^(1/2) = 3. These are expected calculated results; a native Calligra app was not run.

Step 4: If you change C2 from 3 to 4, expected D2 becomes 16 after recalculation. Keep separate base and exponent columns for auditability rather than hard-coding all inputs into every formula.

In a separate region, enter A2 = 1000 (opening amount), B2 = 0.05 (5% rate per period), and C2 = 2 (number of periods). Put this in D2:

=A2*POWER(1+B2;C2)

Expected D2: 1102.5. The period factor 1 + 0.05 = 1.05; POWER(1.05;2) = 1.1025; 1000 × 1.1025 = 1102.50. This is an explanatory arithmetic model before fees, taxes, compounding-calendar differences, or irregular deposits, not a financial-return guarantee. To count only the increase, =D2-A2 is expected to give 102.5.

For a quick conditional status on the exponent table, =IF(D2>10;"Large";"Small") is expected to return Small for D2 = 8. The existing IF tutorial explains that conditional function separately.

• Zero with a negative exponent: The expression 0^-1 would require division by zero and has no finite real result. Do not promise a particular Calligra error label without testing; validate such inputs first.
• Negative base plus a non-integer exponent: Real-valued POWER cannot represent some combinations (for example a square root of −9). Treat an error or an unexpected coercion as a condition to validate against the installed version; the handbook does not enumerate all numeric-domain conventions.
• Zero exponent: For the demonstrated nonzero base 10, exponent 0 yields 1. Avoid generalizing this guide to 0⁰, whose treatment may depend on implementation.
• Percent confusion: Enter 0.05 or a numeric cell genuinely holding 5%, not the numeric value 5, for a 5% factor. Otherwise 1+5 is six, not 1.05.
• Swapped arguments: POWER(C2;B2) is not the same as POWER(B2;C2).
• Display rounding: A cell formatted to zero decimal places may show 0 for 0.25 even when the underlying value is not zero. Inspect number formatting.
• Imported text: Ensure rate and exponent cells contain numbers; the official function signature does not define every text-conversion outcome.

Troubleshooting sequence: Check =POWER(2;3) (official expected 8), then verify = and both numeric inputs, separator and cell references; check negative and zero edge cases; increase displayed decimal places; try reproducing an issue on a fresh sheet. KDE’s Simple Sums manual covers formula entry and cell display. The specific installed package, error code and recalculation status were not measured here.

POWER(base, exponent) describes the same mathematical operation in these programs, but the displayed argument delimiter is locale- and application-dependent: English Calligra examples use semicolons, English Excel examples commonly use commas. Do not assume identical handling for complex results, nonnumeric text, imported formats, or numeric precision without testing the target. The ^ operator is widely used for exponentiation in spreadsheet apps, but this guide verifies the documented POWER function, not a native operator equivalence test.

• IF in Calligra Sheets
• KDE POWER reference — exact syntax, argument types, literal output examples, and POW relationship.
• KDE POW reference
• Pinned Calligra 26.08.2 source registry — POWER registration.
• Official Calligra release listing — 26.08.2 dated 2026-10-08.

• Calligra Sheets — function documentation
• Release code
• KDE formula-entry guide
• KDE POW reference

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.