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 |
|
5.196152423 |
|
0 |
|
1 |
|
-2 |
|