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 theexponentpower. -
exponent- The exponent to raisebaseto.
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 |
|
| 5.196152423 |
|
| 0 |
|
| 1 |
|
| -2 |
|

