POWER Excel Formula


Home >> How to Use Excel Tutorial >> Excel Formulas List >> POWER Excel Formula



The following is the tutorial of POWER function in excel. This function is useful to help you get the power excel formula calculation result of a number.


Why do We Need to Learn POWER Function in Excel?


In doing numeric data processing on a spreadsheet, one of the calculation operations that you can use is power excel formula operation. This operation is sometimes used in a statistical calculation or in an arithmetic operation where we need to multiply a digit with the digit itself a few times. It can be found also in some formulas which are used to analyze business performance.

As an example of this calculation operation usage needs, imagine if we do a calculation on how much is the average growth of some company variables in the last few years. To do the calculation, then we need CAGR formula which has powered numbers operation in it. If there are many digits that we must process in our spreadsheet and the numbers of years that we must look and analyze are different, then probably it will be very difficult to do it if we write the formula manually one by one to get each of the results as needed.

To help you doing this calculation operation easier and faster, then you can use POWER function in excel. This function will help you to do the calculation fast like what you need in the case example above. It will be very useful to be understood and used if you often process data for the needs of statistical, arithmetic, or business performance analysis of a company using some kinds of variables in the spreadsheet.


What is POWER Function in Excel?


POWER function in excel is a function with the usage objective to get power excel formula calculation result from a number. This calculation operation can also be written manually although it might be a little complicated in the writing if we do it that way.

Generally, the input of this function can be explained as follows:


=POWER(number, power)


Notes:
  • number = the number to be powered
  • power = the level of the calculation



How to Use POWER Excel Formula?


The following will explain how to write the POWER function in excel. This formula needs two required inputs which are the numeric data to be processed and the level of the process.


Using the POWER Function in Excel


  1. Type equal sign ( = ) in the cell where you want to put the result in

    POWER Excel Formula - Screenshot of Step 1

  2. Type POWER (can be with large and small letters) and open bracket sign after =

    POWER Excel Formula - Screenshot of Step 2

  3. Input the digit or cell coordinate where the digit which you want to process is after open bracket sign followed by a comma sign ( , )

    POWER Excel Formula - Screenshot of Step 3

  4. Input the level of the calculation or cell coordinate where it is after the comma sign

    POWER Excel Formula - Screenshot of Step 4

  5. Type close bracket sign

    POWER Excel Formula - Screenshot of Step 5

  6. Type Enter
  7. The process is done!

    POWER Excel Formula - Screenshot of Step 7



Exercise


After you have understood how to use the formula, now is the time you do an exercise to sharpen your understanding.

Download the exercise file and do all of the instructions below. Download the answer key file when you have done the exercise and want to check your answers or if you are confused about how to get the results from doing the instructions.

Link of the exercise file:
Download here

Instructions

  1. Use the level of 3 for the power excel formula result of the number at the top!
  2. Use the level of 5 for the power excel formula result of the number at the top!
  3. Calculate the root level of 5 of the number at the top (read the additional note part if you do not know how to do the root calculation by using the formula)!

Link of the answer key file:
Download here


Additional Note


You can also get the root calculation result from this formula. The method is by inputting the number of 1/x with x is the root level that you want in the calculation level input part of the formula.

POWER Excel Formula - Screenshot of Additional Notes 1

POWER Excel Formula - Screenshot of Additional Notes 2





Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!


Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!



Follow our tutorial content also on


CONTACT US PRIVACY POLICY TERMS AND CONDITION AFFILIATE DISCLOSURE @Compute Expert