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.

‍

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