How to Write Exponents in Excel Formulas and Cells

Use the caret symbol (^) to write an exponent in an Excel formula

To write an exponent in Excel, type the caret symbol (^) between the base number and the exponent. For example, to calculate 5 to the power of 3, you would type =5^3 into a cell and press Enter. Excel will return 125.

The caret symbol works in any formula where you need to raise a number to a power. You can use it with cell references, so if cell A1 contains 5 and cell B1 contains 3, typing =A1^B1 will give you the same result. This method works the same way whether you are using Excel on Windows, Mac, or the web version.

The caret is located on the 6 key on most keyboards. You may need to hold Shift to type it, depending on your keyboard layout. If you cannot find it, you can also use the POWER function instead, which does the same thing but uses a different syntax.

Key Takeaways

Type the caret symbol (^) between a number and its exponent to calculate powers in Excel — for example, =2^8 returns 256.
The caret works with cell references, so =A1^B1 will raise the value in A1 to the power of the value in B1.
You can also use the POWER function with the syntax =POWER(base, exponent) to achieve the same result.
Exponents work in any Excel formula and follow standard order of operations, so =2+3^2 returns 11, not 25.

Where to find the caret symbol on your keyboard

The caret (^) is typically located on the 6 key on standard keyboards. To type it, hold Shift and press 6. On some international keyboard layouts, the caret may be in a different location or may require a different key combination — if you are unsure, check your keyboard layout settings in your operating system.

If you cannot locate the caret or prefer not to use it, the POWER function is a reliable alternative. Both methods produce identical results, so choose whichever feels more natural to you.

Using the POWER function as an alternative

The POWER function lets you write exponents using a different format. Instead of =5^3, you would type =POWER(5,3). The first number in the parentheses is the base, and the second number is the exponent. This returns the same result: 125.

POWER works with cell references just like the caret does. If you want to raise the value in A1 to the power of the value in B1, type =POWER(A1,B1). Some people find this syntax easier to read in complex formulas, especially when working with other people who may not be familiar with the caret symbol.

Both the caret and POWER function are equally fast and produce identical results. Use whichever method you find clearer or more comfortable.

How exponents work in longer formulas

When you use exponents in a formula with other operations, Excel follows the standard order of operations. Exponents are calculated before addition and subtraction, but after parentheses. For example, =2+3^2 returns 11 (not 25) because Excel calculates 3^2 first, which equals 9, then adds 2 to get 11.

If you want to change the order of operations, use parentheses. The formula =(2+3)^2 returns 25 because the addition happens first. Parentheses always take priority, so you can use them to control exactly when each part of your formula is calculated.

This matters when you are working with real data. If you are calculating compound interest or scientific values, the order of operations can change your result significantly, so double-check your formula structure before relying on the output.

Displaying exponents as superscript text in a cell

If you want to display an exponent as superscript text (like 5³) rather than calculate it, you need to format the text instead of using a formula. First, type the text you want — for example, "5" and "3" in the same cell. Then select just the "3" by clicking and dragging over it.

With the "3" selected, right-click and choose Format Cells. In the Format Cells window, go to the Font tab and check the Superscript box. Click OK. The "3" will now appear smaller and raised above the baseline, displaying as superscript text.

This method is for display only — it does not perform any calculation. Use this when you are writing text or labels that need to show exponents visually, not when you need Excel to calculate a power.

Common mistakes when typing exponents

The most common mistake is using the wrong symbol. The asterisk (*) is for multiplication, the forward slash (/) is for division, and the hyphen (-) is for subtraction — none of these will calculate an exponent. Only the caret (^) works for powers. If your formula is not returning the result you expect, check that you used the caret and not another symbol.

Another mistake is forgetting the equals sign at the start of your formula. Excel only recognizes something as a formula if it begins with =. If you type 5^3 without the equals sign, Excel will treat it as text and display it as-is rather than calculating the result.

A third issue is mixing up the base and exponent when using the POWER function. Remember that =POWER(5,3) means 5 to the power of 3, not 3 to the power of 5. If your result seems wrong, check that the numbers are in the correct order.

Working with negative exponents and decimals

Negative exponents work the same way as positive ones. The formula =2^-3 returns 0.125 (which is 1 divided by 2³). You can also use cell references with negative exponents — if A1 contains 2 and B1 contains -3, then =A1^B1 will return 0.125.

Decimal exponents also work in Excel. The formula =4^0.5 returns 2 (the square root of 4). The formula =8^(1/3) returns 2 (the cube root of 8). When using decimal exponents, make sure your formula is clear about what you are calculating, especially if other people will be reading your spreadsheet later.

If you are working with very large exponents or very small decimal exponents, your result may display in scientific notation (like 1.23E+10). This is normal and does not mean your calculation is wrong — it is just Excel's way of displaying very large or very small numbers in a compact format.

Frequently Asked Questions

What is the difference between using ^ and the POWER function?

Both produce identical results. The caret (^) is shorter to type, while POWER is sometimes easier to read in complex formulas. Choose whichever you prefer — there is no performance difference between them.

Can I use exponents with negative numbers?

Yes. The formula =(-2)^3 returns -8. Note the parentheses around the negative number — without them, Excel may misinterpret the formula. For even exponents, =(-2)^2 returns 4 (a positive result).

Why is my exponent formula showing as text instead of calculating?

You likely forgot the equals sign at the start. Excel only recognizes formulas that begin with =. If you typed 5^3 instead of =5^3, Excel treats it as text. Delete the cell contents and retype it with the equals sign.

How do I calculate a square root using exponents?

Use the exponent 0.5. The formula =16^0.5 returns 4 (the square root of 16). For a cube root, use 1/3 as the exponent: =27^(1/3) returns 3.

Can I use exponents with columns of data?

Yes. If column A contains numbers and you want to square each one, type =A1^2 in cell B1, then drag the formula down to copy it to the rest of column B. Excel will automatically adjust the cell reference for each row.

This guide is for general information only and is not medical, financial, legal, or other professional advice. For decisions specific to your situation, consult a qualified professional. See our Editorial Policy.