Functions
POWER
Number raised to a power
Try it
When to use it
When should I use POWER instead of the ^ operator?
They compute the same result; POWER(base, exponent) is often easier to read inside long formulas, while ^ is more compact for quick exponents like squares.
How do I take a root with POWER?
Raise the value to a fractional exponent. POWER(27, 1/3) returns the cube root, and POWER(x, 0.5) is the square root.
Use cases
Compound a growth rate over many periods
Take the cube root via a fractional exponent
Used in
Syntax
POWER(number, power)Examples
=POWER(2,4) // => 16
=POWER(3,1.5) // => 5.196152422706632
=POWER(0,10) // => 0