Power
Syntax:¶
POWER(number, power)
- number: The base number you want to raise to a power.
- power: The exponent to which you want to raise the base number.
Examples:¶
-
=POWER(2, 3)would return8because 2 raised to the power of 3 is 2 × 2 × 2 = 8. -
=POWER(5, 2)would return25because 5 raised to the power of 2 is 5 × 5 = 25. -
If you want to calculate the square root of 16, you can use an exponent of 0.5:
=POWER(16, 0.5)would return4.
Note: The
POWERfunction can be replaced with the exponentiation operator^. For example,=2^3is equivalent to=POWER(2, 3). Both return the same result.