Arrow left
Back to guides
Google Sheets Formulas

How to Use POWER Function in Google Sheets

In this article, you will learn how to use the POWER formula in Google Sheets. The power function is beneficial when you want to calculate “X raised to the power of N” for multiple items.

How to utilize the POWER formula in Google Sheets

  1. Type “=POWER(” or go to “Insert”“Function”“Math” → “POWER”.
  2. Select the value for “base” and “exponent” or directly input them.
  3. Press the “Enter” key.
How to insert the POWER function in Google Sheets

The generic formula is as follows:

=POWER(base, exponent)

Base: This figure is the number to be multiplied.

Exponent: This number determines how many times the base figure is multiplied.

Assume you are a finance manager and have a data set. For an item, you want to multiply a value in Data A by the times equal to a value in Data B. In the POWER formula, enter Data A as “base” and Data B as “exponent” for Item A. Then, you can copy and paste the formula vertically to get the calculation results from Item A to J.

How to use the POWER function in Google Sheets

How do you write an exponent on a spreadsheet?

You can use the “^” sign to enter an exponent in a formula.

  1. Type the "=" sign.
  2. Input a base number.
  3. Type the "^" symbol
  4. Type an exponent. For instance, the formula looks like “=2^3”
  5. Press the "Enter" key.
How to write an exponent in Google Sheets

Learn how to do this step-by-step in the video below 👇

Automate financial reporting with LiveFlow

Want to eliminate manual updates of your Excel & Google Sheets models?

Yes, show me how

Need help?

Our team is here to help you any time between 9am and 10pm EST.
Check Icon
Email us at:

Liked this article? Then you'll love the ones below