POWER formula is a mathematical function that calculates a number raised to the power of another number. It returns the result of a base number raised to an exponent.
- How to use
- Examples of using
POWERformula not working?
- Similar formulas to
POWER formula with the syntax shown below, it has 2 required parameters:
- base (required):
The base number that will be raised to the power of the exponent. It can be a number, cell reference, or a formula that returns a number.
- exponent (required):
The exponent to which the base number will be raised. It can be a number, cell reference, or a formula that returns a number.
ExamplesHere are a few example use cases that explain how to use the
POWER formula in Google Sheets.
Calculate compound interest
You can use the
POWER formula to calculate the compound interest on an investment. For example, if you invest $1000 at 5% annual interest rate for 10 years, you can calculate the future value of the investment using the formula
Calculate exponential growth
If you want to calculate the exponential growth of a population, you can use the
POWER formula. For example, if a population grows at a rate of 2.5% per year, you can calculate the population after 10 years using the formula
Calculate area or volume
POWER formula can be used to calculate the area or volume of geometric shapes that have a power relationship between their dimensions. For example, to calculate the volume of a cube with side length 5, you can use the formula
POWER not working? Here are some common mistakes people make when using the
POWER Google Sheets Formula:
Incorrect order of base and exponent
Users often input the exponent first and then the base, resulting in an error. The correct order is to input the base first and then the exponent.
Mistyped function name
Users may accidentally misspell the function name as 'POW' instead of 'POWER', resulting in an unknown function error.
If either the base or exponent input is non-numeric, the formula will result in a #VALUE! error. Ensure both inputs are valid numbers.
The following functions are similar to
POWER or are often used with it in a formula:
SQRTfunction returns the positive square root of a given number. It can be used to find the length of a side of a right triangle, or to calculate standard deviation. The function takes one argument, the value or reference to the cell containing the number for which you want to find the square root.
LOGfunction in Google Sheets returns the logarithm of a given number to a specified base. This function is commonly used in mathematical and financial calculations.
EXPfunction returns the result of e raised to the power of a given exponent. This function is commonly used in mathematical and scientific calculations.
PRODUCTformula in Google Sheets multiplies all the numbers given in the arguments and returns the product. It is commonly used to calculate the total product of a range of cells.
SUMfunction in Google Sheets adds up a range of numbers. This function is most commonly used to sum the values in a range of cells.
You can learn more about the
POWER Google Sheets function on Google Support.