POWER(number, power)
=POWER(2,3)
This example raises 2 to the power of 3. This is equivalent to multiplying 2 by itself 3 times. So the result of this example is 2 x 2 x 2 = 8.
=POWER(2,8)
This example raises 2 to the power of 8. This is equivalent to multiplying 2 by itself 8 times. So the result of this example is 2 x 2 x 2 x 2 x 2 x 2 x 2 x 2 = 256.
POWER(A1,3)
This example raises the value in the cell A1 to the power of 3. This is equivalent to multiplying the value in cell A1 by itself 3 times. So if A1 contains the value 5, the result of this example is 5 x 5 x 5 = 125.
=POWER(27,1/3)
This example raises the number 27 to the power of 1/3. This is equivalent to finding the cube root of 27. So the result of this example is 3.
=POWER(81,1/4)
This example raises the number 81 to the power of 1/4. This is equivalent to finding the fourth root of 81. So the result of this example is 3.
=POWER(256,1/8)
This example raises 256 to the power of 1/8, which is the same as computing the eighth root of 256.
The POWER function is used to multiply a number by a power. It requires two arguments, the base number and the power, and the base number can be any real number.