Excel POWER Function
The Excel POWER function returns a number raised to a given power. The POWER function is an alternative to the exponent operator (^).
- number - Number to raise to a power.
- power - Power to raise number to (the exponent).
The POWER function returns a number raised to a given power. POWER is an alternative to the exponent operator (^) in a math equation.
The POWER function takes two arguments: number and power. Number should be a numeric value, provided as a hardcoded constant or as a cell reference. The power argument functions as the exponent, indicating the power to which number should be raised.
To raise 2 to the 3rd power, you can use POWER like this:
=POWER(2,3) // returns 8
To raise 2 to the 8th power:
=POWER(2,8) // returns 256
To cube the value in cell A1:
=POWER(A1,3) // cube A1
To use the power function with a fractional exponent, enter the fraction directly as the power argument:
In Excel, exponentiation can also be handled with the exponent (^) operator, so: