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.
Examples
To raise 2 to the 3rd power, you can use POWER like this: To raise 2 to the 8th power: To cube the value in cell A1:
Fractional exponents
To use the power function with a fractional exponent, enter the fraction directly as the power argument:
Exponent operator
In Excel, exponentiation can also be handled with the exponent (^) operator, so:
Dave Bruns
Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.
