Go Back

Excel POWER Function

Figure 1. of Excel POWER Function.

In the event that we want to determine a very small level of tolerance for vast distances. At some point we will have to raise a number to a specific power. We are going to utilize the Excel POWER Function. This article will walk through how to do it.

Generic Formula

POWER(number, power)

The POWER Function will calculate a number raised to a specific power. The formula syntax has the following components;

  • number – the number value which we desire to raise to a certain power. This can be any real number.
  • power – the exponential value to which we are going to raise our base number.

How to use the Excel POWER Function.

We can achieve this by following three simple steps!

  1. Collect the data available to us for checking, in our Excel sheet. See example illustrated below;

Figure 2. of Number Values for the POWER Function in Excel.

  1. Our purpose here is to exponentially raise the number values in column A to the power Values specified in column B of our worksheet. The formula syntax which we will enter into the formula bar for cell C2, for the desired result is as follows;


Figure 3. of the POWER Function in Excel.

  1. Modify and copy the formula syntax into the other cells in column C of the example illustrated below to achieve the desired results.

Figure 4. of the POWER Function in Excel.

The POWER Function operates like an exponential value in a basic mathematical equation.

Figure 5. of Final Result.

Instant Connection to an Expert through our Excelchat Service

Our live Excelchat Service is here for you. We have Excel Experts available 24/7 to answer any Excel questions you may have. Guaranteed connection within 30 seconds and a customized solution for you within 20 minutes.

Did this post not answer your question? Get a solution from connecting with the expert.

Another blog reader asked this question today on Excelchat:
Here are some problems that our users have asked and received explanations on

Can you recommend the best way to learn and understand Power BI - Power Query - Power Pivot - Power View etc
Solved by D. F. in 22 mins
Create a new Power View report (add the Power View button to the Quick Access Toolbar, if necessary). The new sheet will be named Power View1 automatically. If necessary, rename the sheet Power View1.
Solved by M. W. in 21 mins
I would like to create the formulas for higher-power regressions (2nd power, 3rd power, 4th power). I can see the formulas on the charts, but I want the coefficients to be automatically placed into cells so I can use the formulas in my tables.
Solved by B. Y. in 22 mins

Leave a Comment