• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Exponents in Excel

March 11, 2021 by Andrew Childress
Exponents in Excel

Exponents refer to how many times a number should be multiplied by itself. Let's learn how to work with exponents in Excel.

Exponents refer to how many times a number should be multiplied by itself in a given scenario. 10 with an exponent of 3 is typed 103, and equals 10*10*10 or 1,000. Let’s learn how to work with exponents in Microsoft Excel.

How to Find Exponents with the Power Formula

Excel offers you multiple ways of working with exponents. The first is called the Power formula.

Imagine you have three numbers, and you want to apply the exponent of 5 (called the power) to them.

Click into empty cell B2. Type =, the universal start of every Excel formula. Continue by typing POWER(. Remember, you want to raise the value in cells A2, A3, and A4 to the 5th power.

Exponents in Excel

Go ahead and click into cell A2. Your formula now reads:

=POWER(A2,

Continue by typing in your power, 5, and finally 5. Your formula now is:

=POWER(A2,5)

How to find exponents in Excel

Hit Enter on your keyboard, and you’ll see your solution: 3,125.

Now, in Excel, there’s no need to type formulas over and over. Instead, hover over cell B2‘s lower right corner. When you see the + appear, click and drag the formula downwards to fill cells B3 and B4.

Exponents in Microsoft Excel

Excel will automatically apply your formula to the values in cells A3 and A4.

How to Quickly Raise Any Number to a Power in Excel

Quick, what’s 17 raised to the 4th power? Likely, you don’t know the answer off the top of your head. Fortunately, Excel offers a fast, formula-driven shortcut to help you find out.

Click into any empty cell. Once again, type =, followed by your number, 17.

You should see:

=17

Next, type in a caret ^ symbol, followed by your power.

Your formula is now:

=17^4

How to use exponents in Microsoft Excel

 

Hit Enter, and Excel returns your solution: 83,521.

As you can see, Excel makes working with exponents a breeze by offering you a pair of quick formula options.

Category: Excel FormulasTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:Customize Excel scatter plotScatter Plot in Excel
Next Post:Subscript in ExcelSubscript in Excel font menu

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top