On the Formulas tab, under Function, click Formula Builder.
In the Formula Builder, type POWER in the search box, and then double-click POWER in the list.
Under Arguments, click the box next to number, and then type the number that you want to raise to a power, such as 5.
Under Arguments, click the box next to power, and then type the power that you want to raise the number to.
For example, to square the number, type 2.
Press RETURN .
If you typed 5 and 2, the result is 25.
Tip: You can also use a ^ (carat) — the calculation operator for exponentiation — to raise a number to a power. For example, type =5^3 to calculate five cubed, which is 125.
Raise a number to a power