Skip to main content
  • Login
Cart
Exceljet logo Exceljet
  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles
Cart
  • Login
  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles
  • Login

You are here

Home › Videos › How to use exponents in a formula

How to use exponents in a formula

Transcript 

Let's look at how to use exponents in Excel. Exponents are entered using the caret symbol which is above the number 6 on the keyboard. For example, the formula for 3 squared is entered as = 3 ^ 2.

Let's take a look.

Like previous examples, we have a simple worksheet that highlights several cell references. Following the instructions in the table, let's create the formulas we need to use exponents.

The first formula doesn't use any cell references. For 3 squared, we input = 3 ^ 2  which gives us 9.

Excel doesn't care about white space in formulas, so feel free to add space for better readability.

The second example is C9 cubed. For that, we enter = C9 ^ 3 which gives us 27.

Next, we have F7 to the power of D6 which translates to F7 ^ D6.

Because D6 is negative one, we get the inverse of F7, or one fourth.

In the last example, we need to raise H8 to the power of H11. This is H8 ^ H11.

When using exponents, you may see a VALUE error if any of the cells contain text. Blank values can cause a "divide by zero" error when the exponent is negative.

Master Excel with practice. Download this worksheet (and dozens more) in our Core Excel course. Learn by doing.

Dave Bruns Profile Picture

Author

Dave Bruns

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.

Microsoft Most Valuable Professional Award  

Exceljet Training

  • Excel 101
  • Excel Fundamentals
  • Conditional Formatting
  • Essential Formulas
  • Advanced Formulas
  • Pivot Tables
  • Excel Tables
  • Excel Shortcuts
  • Excel Charts
  • Course Bundles
Just wanted to say you are my go to website for any excel question for good few years and taught me a lot. No other resource can explain the steps better than you do. You made such a difference. It is amazing.
Al
More Testimonials

Get Training

Quick, clean, and to the point training

Learn Excel with high quality video training. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed. Each video comes with its own practice worksheet.

View Paid Training & Bundles
Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Charts video training course
Video training for Excel Tables
Dynamic Array Formulas
Exceljet logo Exceljet
Quick, clean, and to the point

Resources

  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles

About Us

  • About
  • Testimonials
  • Topics
  • Contact
  • Donate

Newsletter Sign-up

Work faster in Excel. Join more than 100,000 people who get weekly tips from us.
© 2012-2025 Exceljet. Terms of use
  • Visit our Twitter page