POWER Function in Google Sheets: Examples, Pitfalls & Compatibility
POWER in Google Sheets: raise a number to an exponent, including roots and reciprocal powers. Includes worked examples and application-specific cautions.
Verification status: Official documentation referenced; example outcomes independently reasoned or arithmetically checked where stated. Not executed in Google Sheets. How formula examples are checked
Quick answer: Use POWER in Google Sheets to raise a number to an exponent, including roots and reciprocal powers. The official POWER reference is the source for the function definition and platform-specific rules described below.
Syntax and arguments
=POWER(base, exponent)
base (required): The base being raised to a power.
exponent (required): The exponent, which may be an integer, fraction or negative number subject to the real-valued domain.
Examples use English function names, comma argument separators and decimal points. Adapt formula separators to your workbook settings, not punctuation inside quoted text.
When to use it
Use POWER when the model is exponentiation rather than multiplying two independent inputs. A power of 3 means three copies of the base are multiplied; it does not mean the base is multiplied by the number 3.
Three worked examples
Each example is independent. Where input cells are listed, enter those values first; otherwise the formula is self-contained. Expected outputs are independently checked calculations or documented error expectations, not captured results from Google Sheets.
Example 1: Calculate a cube
=POWER(5,3)
Expected result: 125.
Three factors of 5 produce 125.
Example 2: Calculate a positive square root
=POWER(81,0.5)
Expected result: 9.
The example is deliberately inside the positive-base real domain.
Example 3: Use a negative exponent
=POWER(2,-3)
Expected result: 0.125.
The result is 1 divided by 2 cubed, or one eighth.
Put it to work safely
Put the base and exponent in separate labelled cells for a reusable model. Test an integer exponent, a positive-base root and a reciprocal power before extending the calculation. Parentheses make negative bases and compound exponents explicit. Avoid assuming that a rounded decimal representation of a rational exponent has exactly the same domain behavior as the original fraction.
Common mistakes and fixes
The result differs from base times exponent. Exponentiation and multiplication are different operations. Review the mathematical model.
A root of a negative base fails or changes on import. Real roots of negative values depend on the exponent and the application’s treatment of it. Test the exact expression rather than assuming all fractional powers are equivalent.
A zero base and negative exponent is requested. That would require division by zero mathematically. Validate the model domain instead of inventing a finite result.
Google Sheets-specific notes
Google’s official POWER examples explicitly include a negative cube-root expression. That is useful evidence for that particular expression, not permission to assume every negative base and fractional exponent works. The basic comparison examples below use positive bases. See the vendor reference for the current definition.
Excel and Google Sheets comparison
Both applications document exponentiation, but negative fractional bases deserve separate compatibility tests. Google documents POWER(-8,1/3) as -2; this guide does not claim that the same expression was executed in Excel or that all rational exponents are equivalent.
Compare the POWER guide for Microsoft Excel and its official documentation. Having a guide in both libraries establishes two documented references, not a certificate of identical behavior across releases, locales or file conversions.
Related guides
SQRT, PRODUCT, LOG, EXP · All Google Sheets functions.
Evidence and testing scope
Editorial verification: Official references retrieved on 2026-10-12. The three worked cases are included in this release’s reproducible Python checking suite. It checks the stated arithmetic, calendar or text model and the expected documented error classification; it is not the Google Sheets calculation engine. No native application run, UI screenshot, maximum-size benchmark or cross-version certification is claimed. Review the editorial testing standards before relying on a formula in a critical workbook.