POWER Function Generator
POWER raises a number to the power of an exponent. Equivalent to using ^ but more readable inside long formulas.
Syntax
=POWER(number, power)Try it — generate a POWER formula
Examples
Square a value
=POWER(A2, 2)A2 squared.
Compound interest
=Principal*POWER(1+Rate, Years)Future value formula.
Cube root
=POWER(A2, 1/3)Fractional exponent for nth root.
Tips
- ✓^ operator is equivalent: A2^2 == POWER(A2, 2).
- ✓Use fractional exponents for roots: POWER(x, 1/n) is the nth root.
- ✓Negative bases with non-integer exponents return #NUM!.
Related Formulas
MOD
MOD returns the remainder after one number is divided by another. Common uses: a...
ROUND / ROUNDUP / ROUNDDOWN
Three rounding functions: ROUND (nearest), ROUNDUP (always up), ROUNDDOWN (alway...
CEILING / FLOOR
CEILING rounds up to the nearest multiple of a given number; FLOOR rounds down. ...
Need a different formula?
Describe any formula in plain English and FormulaPad will generate it.
Try FormulaPad Free