To raise a number to a power in Excel, use the caret operator: with the base in A2 and the exponent in B2, enter =A2^B2. You can also use =POWER(A2,B2); both return the base raised to the exponent.
The basic Excel power formula
A power has two parts: the base, which is the number being multiplied, and the exponent, which tells Excel how many times to use that base. For example, a base of 3 raised to a power of 4 means 3 multiplied by itself four times, giving 81. Excel uses the caret character, ^, for this operation.
For a self-contained example entered directly in a worksheet, the formula =3^4 returns 81. This is useful for a quick calculation, but cell references are usually easier to update and reuse. If the base is in A2 and the exponent is in B2, the formula =A2^B2 calculates the power from those cells. With A2 set to 3 and B2 set to 4, the result is 81.
Excel also provides the POWER function. With the base in A2 and exponent in B2, enter =POWER(A2,B2). The same example, with A2 equal to 3 and B2 equal to 4, returns 81. The function takes two arguments in this order: the number to raise, then the power. In Microsoft 365 for Windows, formulas use commas between arguments under the usual regional settings; some regional settings use semicolons instead.
Using ^ and POWER with cell references
The caret and POWER function perform the same basic calculation, so choose whichever makes your worksheet clearest. The caret is compact and familiar when a formula combines several arithmetic operations. POWER can make the role of each input easier to read, especially for someone who does not immediately recognize the caret as an operator.
With the base in A2 and the exponent in B2, =A2^B2 and =POWER(A2,B2) return the same result. If A2 contains 5 and B2 contains 3, either formula returns 125. If you change B2 to 4, the result updates to 625. This makes a formula more flexible than typing a fixed calculation such as 5 raised to 3 directly into every row.
To apply one exponent to a list of bases, put the bases in A2:A6 and enter the shared exponent in B1. In C2, use =A2^$B$1, then fill the formula down through C6. The dollar signs keep the exponent reference fixed as the formula is copied. If A2 is 2 and B1 is 3, C2 returns 8. The next row uses its own base but still refers to B1.
In Excel for Windows, you can fill a formula down by dragging the fill handle at the lower-right corner of the selected cell, or use Ctrl+D after selecting the formula cell and the cells below it. On a Mac, the fill-down shortcut is Control+D. Excel for the web also supports the fill handle; shortcut behavior can depend on your browser and keyboard settings.
Negative and fractional exponents
An exponent does not have to be a positive whole number. A negative exponent means to take the reciprocal of the base raised to the corresponding positive power. For instance, 2 raised to negative 3 is 1 divided by 8, or 0.125. With the base in A2 and exponent in B2, the formula =A2^B2 returns 0.125 when A2 is 2 and B2 is -3. The POWER function handles negative exponents in the same way.
A fractional exponent can represent a root. An exponent of one-half gives the square root for a positive base; an exponent of one-third gives the cube root for a positive base. With the base in A2 and exponent in B2, =A2^B2 returns 4 when A2 is 16 and B2 is 0.5. For a positive base of 27 and an exponent of one-third, the same pattern returns 3.
Be careful with negative bases and fractional exponents. Excel’s ordinary worksheet power calculation uses real-number results, and a negative base raised to many fractional exponents produces #NUM!, because the corresponding result is not a real number. For example, a cube root of a negative number is real in mathematics, but entering a negative base with an exponent of one-third may still produce an error in Excel’s standard power calculation. If you need a particular real-valued odd root for negative inputs, handle the sign separately rather than assuming the fractional-power formula will return it.
Calculating growth over time
Power formulas are useful when a quantity changes by the same percentage each period. In a basic compound-growth calculation, the starting amount is multiplied by one plus the growth rate, raised to the number of periods. This pattern applies to illustrative scenarios such as population or repeated percentage growth. For money decisions, it is only a calculation example; check actual product terms with the lender or a qualified professional.
Suppose B2 contains a starting amount of 1000, C2 contains a periodic growth rate of 5%, and D2 contains 3 periods. Enter =B2*(1+C2)^D2 to calculate the ending amount. The result is 1157.625: 1000 multiplied by 1.05 three times. Format the result as currency or round it for display if appropriate, but remember that formatting does not change the underlying stored value.
This formula assumes the rate is applied once per period and remains constant, with each period’s change included in the amount for the next period. If the rate applies monthly but the number of periods is in years, the formula needs to reflect the monthly rate and the total number of months. A simple annual rate and a monthly rate are not interchangeable. Make sure the rate and period count use matching units before interpreting the result.
How EXP differs from a power formula
Excel’s EXP function is related to powers, but it does not mean raise any chosen base to any chosen exponent. EXP returns the mathematical constant e raised to the supplied value. The constant e is approximately 2.71828, so EXP(x) calculates e^x. Use the caret or POWER when you need a base of your choice; use EXP when the model specifically calls for the natural exponential function.
With the input value in A2, enter =EXP(A2). If A2 contains 2, the result is approximately 7.389056. That is different from raising 2 to the power of 2, which is 4. With a chosen base in A2 and exponent in B2, =A2^B2 calculates that general power instead. This distinction matters in scientific formulas and continuous-growth models, where the natural base e is part of the model.
A common source of confusion is the phrase exponential power. In everyday spreadsheet questions, it often means raising a number to an exponent, which is done with ^ or POWER. It can also refer to exponential growth or to the EXP function. Identify the intended base and exponent first: if the base is not specified as e, a general power formula is usually the relevant operation.
Parentheses, order of operations, and common errors
Excel follows an order of operations, so parentheses can determine which value is raised to a power. If the base is a negative number, put it in parentheses. With the intended base of negative 2 in A2 and the exponent 2 in B2, =A2^B2 returns 4 when A2 contains -2. If instead you type =-2^2, Excel treats the exponentiation before the leading negative sign, producing -4. Parentheses make the intended calculation explicit.
Another frequent mistake is multiplying instead of exponentiating. The formula =A2*B2 multiplies the two cell values; it does not raise A2 to the power in B2. If A2 is 4 and B2 is 3, multiplication returns 12, while =A2^B2 returns 64. Check that you used the caret or POWER when the task says raised to, squared, cubed, or to the power of.
Errors can also come from the input data. A cell that contains text which Excel cannot interpret as a number may cause a value error, while unsupported real-number results, such as many negative-base fractional powers, can return #NUM!. A very large calculation can also exceed Excel’s numeric range. Check the base and exponent cells, confirm that values are actually numeric, and test a smaller example if the result is unexpected.
For a square, an exponent of 2 is usually the clearest choice; for a cube, use 3. The caret works for either, and POWER is not required for these common cases. For a square root of a nonnegative number, Excel also has the SQRT function. With a nonnegative value in A2, =SQRT(A2) returns its square root. For other roots, a fractional exponent is a compact option, subject to the negative-base limitation described above.
Choosing the right method
Use ^ for a short, general power calculation, including formulas that combine powers with multiplication or addition. Choose POWER when naming the inputs makes a complex formula easier to review. Choose EXP only when the required base is e. Use SQRT when you specifically need a square root and the input is nonnegative. These methods are built into Excel and do not require enabling an add-in.
For a worksheet that others will maintain, label the input columns clearly, such as Base, Exponent, and Result. Keep the exponent in a separate cell when it may change, and use absolute references for a shared input when copying formulas. For a one-off calculation, entering a literal formula is fine; for a repeated calculation, references reduce retyping and make assumptions visible.
Frequently Asked Questions
What is the Excel formula for a number to the power of 2?
Use the caret followed by 2. With the number in A2, enter =A2^2. If A2 is 6, the result is 36. You can also use =POWER(A2,2).
How do I raise a number to a power stored in another cell?
Put the base in one cell and the exponent in another. With the base in A2 and exponent in B2, use =A2^B2 or =POWER(A2,B2). The result updates when either input changes.
Is POWER better than the caret in Excel?
Neither is generally more accurate for ordinary power calculations. Both are valid ways to raise a number to an exponent. The caret is shorter, while POWER can make the base and exponent more explicit in a long formula.
How do I calculate a cube root in Excel?
For a positive value in A2, use =A2^(1/3). For example, if A2 is 27, the result is 3. Be aware that negative inputs with fractional exponents can return #NUM! in Excel.
Why does Excel show #NUM! for a power formula?
One possible cause is a negative base raised to a fractional exponent that has no real-number result. A calculation that exceeds Excel’s numeric range can also fail. Check the sign and size of the base, the exponent, and whether the intended result should be real-valued.
Related
- Data Validation Process: Steps, Checks, and Best Practices
- Data Validation Named Range in Excel: Setup and Fixes
- Data Validation Reference Table in Excel
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Rows in Excel Nederlands: Meaning and the RIJEN FunctionIn Dutch, Excel rows are called rijen; the English Excel function ROWS is named RIJEN in Dutch-language Excel.…
- PMT Function in SQL: Calculate Loan Payments by PeriodSQL does not have a universally available built-in PMT function. To calculate a fixed loan payment, use the…
- INDEX MATCH With Two MATCH Functions: Practical ExamplesYes: the standard two-way lookup uses INDEX with one MATCH to find a row and a second MATCH…
- Excel MIN IF: Find the Smallest Value That Meets a TestTo find the smallest value in Excel that meets a condition, use MINIFS in Microsoft 365: with regions…
- Excel Data Table Tutorial: One- and Two-Variable What-IfsTo create an Excel Data Table, place a formula and test values in a small grid, select the…
- Excel Date Range Between Two Dates: Formulas and ExamplesTo calculate the number of days between two dates in Excel, subtract the earlier date from the later…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.