Skip to content

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:

  1. =POWER(2, 3) would return 8 because 2 raised to the power of 3 is 2 × 2 × 2 = 8.

  2. =POWER(5, 2) would return 25 because 5 raised to the power of 2 is 5 × 5 = 25.

  3. If you want to calculate the square root of 16, you can use an exponent of 0.5: =POWER(16, 0.5) would return 4.

Note: The POWER function can be replaced with the exponentiation operator ^. For example, =2^3 is equivalent to =POWER(2, 3). Both return the same result.