POWER

Formulas / POWER
Raise 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?
The POWER function is a mathematical expression that takes a number and a power as arguments and raises the number to the power indicated.
What arguments does POWER require?
POWER requires two arguments: a number and a power. The number argument is the base number, and the power argument is the exponent to raise the base number to.
What is the difference between the POWER function and the ^ operator?
The POWER function and the ^ operator both raise the base number to a certain power, however the POWER function is useful when a more descriptive statement is desired.
Can the POWER function be used in place of the ^ operator?
Yes, the POWER function can be used in place of the ^ operator when you want to indicate to what power the base number should be raised.
Sourcetable Logo

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code.

Drop CSV