The POWER function returns a number raised to a power. Both arguments are number values.
POWER(number, exponent)
number: The number to be raised to the given power.
exponent: The power to which the given number should be raised.
Notes
The POWER function produces the same result as the ^ arithmetic operator: =POWER(x, y) returns the same result as =x^y.
Examples |
|---|
=POWER(2, 3) returns 8. =POWER(2, 10) returns 1,024. =POWER(0.5, 3) returns 0.125. =POWER(100, 0.5) returns 10. |