Use =POWER(number,power) to raise a base number to an exponent. For example, =POWER(2,3) has an independently calculated expected result of 8 because 2×2×2=8.

Raise a number to an exponent for squares, cubes, inverse powers and growth models. 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.

=POWER(number, power)

ONLYOFFICE POWER documents precisely those two arguments in that order. Neither is labelled optional. Fractional exponents can represent roots where a real result exists; negative exponents give reciprocals for nonzero bases. Special cases such as zero to zero or negative bases with fractional powers are not sufficiently specified by the unversioned vendor page to promise particular errors in ONLYOFFICE.

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.

Start in F2 with =POWER(D2,E2) and copy through F7 after entering the dataset. The results follow ordinary real-number exponent arithmetic and were not observed in ONLYOFFICE.

Growth factor and compounded value

Assume an illustrative rate of 5% per period over three periods, with the rate remaining constant:

=POWER(1+0.05,3)

The expected growth multiplier is 1.157625. A starting amount of 100 would become =100*POWER(1+0.05,3) → 115.7625 before any rounding, taxes, fees or real-world assumptions. Enter rate 0.05 in H2 and periods 3 in I2; then =POWER(1+H2,I2) reproduces the multiplier. Using actual input cells allows a scenario table without editing formulas.

A simple algebraic equivalence for ordinary real, valid numeric inputs is =POWER(4,2) = 16; Excel officially also documents =4^2, but the exact operator interpretation should be tested in the target ONLYOFFICE build before claiming version-specific equivalence. See the Excel POWER function note.

Do not confuse compound growth with a growth rate: POWER(1+rate,periods) is the multiplier; subtract 1 only when a cumulative gain fraction is required (0.157625 in this example).

If an answer looks too large or small, inspect whether the exponent is 3 vs 0.03, and whether a percentage was entered as 5% (0.05) vs 5 (500%).

Microsoft’s Excel POWER function uses the same (number,power) argument order and explicitly documents ^ as an alternative. The LibreOffice Calc mathematical function reference writes the comparable syntax as POWER(Base; Exponent) and documents subtle negative-base/fractional-exponent cases (including cases that return #NUM!). Neither cross-product fact proves ONLYOFFICE’s detailed error or fractional-exponent behaviour. For ordinary numeric bases and integer exponents the definitions align; portability-sensitive edge cases are deliberately flagged for native tests.

• ONLYOFFICE SQRT — dedicated positive square-root function.
• ONLYOFFICE ABS — unsigned magnitude, not exponentiation.
• ONLYOFFICE ROUND — control the displayed/calculated decimal digits explicitly.

• ONLYOFFICE Spreadsheet Editor — function documentation
• Docs release history
• Desktop Editors release history
• ONLYOFFICE’s formula-entry instructions
• official regional settings instructions
• LibreOffice Calc mathematical function reference
• ONLYOFFICE SQRT

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.