Raise a number to a power

  1. On the Formulas tab, under Function, click Formula Builder.

    Formulas tab, Function group

  2. In the Formula Builder, type POWER in the search box, and then double-click POWER in the list.

  3. Under Arguments, click the box next to number, and then type the number that you want to raise to a power, such as 5.

  4. 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.

  5. 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.

See also

IMPOWER function

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!