Returns a number raised to a power.
Sample Usage
POWER(4,0.5)
POWER(A2,B2)
POWER(2,5)
Syntax
POWER(base, exponent)
base
- The number to raise to theexponent
power.exponent
- The exponent to raisebase
to.
See Also
SQRTPI: Returns the positive square root of the product of Pi and the given positive number.
SQRT: Returns the positive square root of a positive number.
LOG10: Returns the logarithm of a number, base 10.
LOG: Returns the logarithm of a number given a base.
LN: Returns the logarithm of a number, base e (Euler’s number).
GAMMALN: Returns the logarithm of a specified Gamma function, base e (Euler’s number).
EXP: Returns Euler’s number, e (~2.718) raised to a power.
Examples
General use of POWER function
Result | Formula |
---|---|
16 | =POWER(2, 4) |
5.196152423 | =POWER(3, 1.5) |
0 | =POWER(0, 10) |
1 | =POWER(10, 0) |
-2 | =POWER(-8, 1/3) |