POWER Function (LibreOffice Calc)
The POWER function in LibreOffice Calc raises a number to a specified exponent. Learn syntax, examples, common errors, and best practices.
Compatibility
▾| Excel | ✔ |
| Gnumeric | ✔ |
| Google_sheets | ✔ |
| Libreoffice | ✔ |
| Numbers | ✔ |
| Onlyoffice | ✔ |
| Openoffice | ✔ |
| Wps | ✔ |
| Zoho | ✔ |
What the POWER Function Does â–¾
- Raises a number to a specified exponent
- Supports positive, negative, and fractional exponents
- Works with integers, decimals, and expressions
- Useful for growth models, compounding, geometry, and scientific math
- Equivalent to the
^operator
It is designed to be precise, flexible, and universally compatible.
Syntax â–¾
POWER(number; exponent)
Arguments
-
number:
The base value. -
exponent:
The power to raise the base to.
Examples:2→ square3→ cube0.5→ square root-1→ reciprocal
Basic Examples â–¾
Square a number
=POWER(5; 2)
Returns 25.
Cube a number
=POWER(3; 3)
Returns 27.
Square root using POWER
=POWER(16; 0.5)
Returns 4.
Reciprocal using POWER
=POWER(10; -1)
Returns 0.1.
POWER with a cell reference
=POWER(A1; 2)
Squares the value in A1.
Advanced Examples â–¾
Exponential growth
=POWER(1 + A1; B1)
Useful for compound interest or growth factors.
POWER with negative bases
=POWER(-2; 3)
Returns -8.
Fractional exponents (roots)
=POWER(A1; 1/3)
Returns the cube root of A1.
POWER with formulas
=POWER(A1 - B1; 2)
Squares the difference between A1 and B1.
Equivalent using ^ operator
=A1 ^ 2
Same result as POWER(A1; 2).
POWER for geometry
=POWER(A1; 2) + POWER(B1; 2)
Useful for Pythagorean calculations.
Common Errors and Fixes â–¾
Err:502 — Invalid argument
Occurs when:
- number is negative and exponent is fractional
- exponent or number is non-numeric
- the expression results in an undefined value
Fix:
Ensure the exponent is compatible with the base.
Err:503 — Numeric overflow
Occurs when:
- The result is too large for Calc to represent
Example:POWER(10; 400)
Fix:
Scale inputs or use logarithmic transformations.
POWER returns a complex number (not supported)
Cause:
- Negative base with non-integer exponent
Example:POWER(-4; 0.5)
Calc cannot compute imaginary results.
Best Practices â–¾
- Use POWER for clarity when formulas become complex
- Use the ^ operator for quick inline exponentiation
- Avoid fractional exponents on negative bases
- Use POWER for growth, compounding, and geometric formulas
- Use SQRT for readability when exponent is 0.5
Related Patterns and Alternatives â–¾
- Use SQRT for square roots
- Use EXP for natural exponentiation
- Use LN or LOG for logarithmic transformations
- Use A1 ^ B1 as a shorthand for POWER(A1; B1)
- Use PRODUCT for multiplication-based growth models
By mastering POWER and its combinations with other math functions, you can build precise, scalable numeric models in LibreOffice Calc that handle exponentiation cleanly and consistently.