POWER
Formulas / POWERRaise a number to a power.
POWER(number, power)
- Number - the base number (required)
- Power - the exponent to which the base number is raised to (required)
Examples
=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.
Summary
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.
- The POWER function is an alternative to the exponent operator (^) for equations.
- The arguments for the POWER function are number and power. Both arguments are required.
- The power argument is the power to raise a number to.
Frequently Asked Questions
What is the POWER function?
What arguments does POWER require?
What is the difference between the POWER function and the ^ operator?
Can the POWER function be used in place of the ^ operator?
