Returns the result of a number raised to a given power.
Cú pháp
POWER(number, power)Đối số
numberbắt buộc
The base number you want to raise to a power.
powerbắt buộc
The exponent to which the base number is raised.
The POWER function calculates the value of a base number raised to a specified exponent. It is equivalent to using the caret (^) operator in Excel formulas.
=POWER(5, 2)→25Calculates 5 squared.
=POWER(8, 1/3)→2Calculates the cube root of 8.
Select a cell
Click on the cell where you want to display the result.
Enter the formula
Type =POWER(number, power) and replace the arguments with your desired values or cell references.
Press Enter
Press the Enter key to calculate the result.
No, they are functionally identical; =POWER(A1, 2) produces the same result as =A1^2.