How to Use Negative Exponents in Excel (3 Easy Methods)

Negative Exponents in Excel
Get FREE Advanced Excel Exercises with Solutions!

If you want to use negative exponents in Excel, you have come to the right place. Here, we will walk you through 3 easy and effective methods to do the task smoothly.


How to Use Negative Exponents in Excel: 3 Easy Methods

In the following dataset, you can see the Base and Exponent columns. Here, you can easily notice that the Exponent column has negative exponents. Furthermore, using this dataset, we will go through 3 easy methods to use negative exponents in Excel. Here, we used Excel 365. You can use any available Excel version.

Dataset for Negative Exponents in Excel


1. Use of Keyboard Shortcut to Use Negative Exponents in Excel

In this method, we will use the keyboard shortcut SHIFT+6 to use negative exponents in Excel. Here, the SHIFT+6 keys will bring out the ^ symbol, which is used to type the power over a base number. We can use the negative exponent after the ^ symbol.

Steps:

  • In the beginning, we will type the following formula in cell D5.
=B5^C5

Here, first, we typed =B5, and after that, we used the SHIFT+6 keys to bring out the ^ symbol. Then, we type C5.

Using Keyboard Shortcut to Use Negative Exponents in Excel

  • After that, press ENTER.

Therefore, you can see the result in cell D5.

  • Furthermore, we will drag down the formula with the Fill Handle tool.

Therefore, you can see the complete Result column.


2. Using POWER Function in Excel

In this method, we will use the POWER function to use negative exponents in Excel. This is a quick and handy method to use negative exponent.

Steps:

First of all, we will type the following formula in cell D5.

=POWER(B5,C5)

Applying POWER Function to Use Negative Exponents in Excel

Formula Breakdown

  • POWER(B5,C5) → The POWER function returns the outcome of a number raised to a power.
  • B5 →is the number.
  • C5 → is the power.
    • Outcome: 0.25
  • Explanation: Here, 25 is the result of the base 2 raised to a negative exponent -2.
  • After that, press ENTER.

At this point, you can see the result in cell D5.

  • Furthermore, we will drag down the formula with the Fill Handle tool.

Using Fill Hanlde tool for Negative Exponents in Excel

As a result, you can see the complete Result column.

Read More: How to Calculate Exponential in Excel


3. Employing EXP Function for Using Negative Exponents

Here, in the Base column, you can see the base is e (Euler’s Number). Further, we will find out the negative exponent of base e using the EXP function.

Steps:

  • In the beginning, we will type the following formula in cell D5.
=EXP(C5)

Applying EXP Function to Use Negative Exponents in Excel

Formula Breakdown

  • EXP(C5) → the EXP function returns e (Euler’s Number) raised to the power of number.
  • C5 → is the number
  • Output: 0.135335283
  • Then, press ENTER.

Therefore, you can see the result in cell D5.

  • Furthermore, we will drag down the formula with the Fill Handle tool.

Hence, you can see the complete Result column.

Read More: How to Use Excel Exponential Function of Base 10


How to Use Positive Exponents in Excel

Here, we will show you how you can use positive exponent in Excel. In the following dataset, you can in the Exponent column, the values of the exponents are positive. Then, we will use the POWER function to use positive exponents in Excel.

Steps:

  • In the first place, we will type the following formula in cell D5.
=POWER(B5,C5)

Formula Breakdown

  •  POWER(B5,C5) → The POWER function returns the outcome of a number raised to a power.
  • B5 →is the number.
  • C5 → is the power.
    • Outcome: 4
  • Explanation: Here, 4 is the result of the base 2 raised to a positive exponent 2.
  • After that, press ENTER.

At this point, you can see the result in cell D5.

  • Furthermore, we will drag down the formula with the Fill Handle tool.

As a result, you can see the complete Result column.


Practice Section

You can download the above Excel file to practice the explained method.


Download Practice Workbook

You can download the Excel file and practice while you are reading this article.


Conclusion

Here, we tried to show you 3 easy methods to use negative exponent in Excel. Thank you for reading this article, we hope this was helpful. If you have any queries or suggestions, please let us know in the comment section below.


Related Articles


<< Go Back to Excel EXP Function | Excel Functions | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Afia Kona
Afia Kona

Afia Aziz Kona, a graduate of Civil Engineering from Khulna University of Engineering & Technology, Bangladesh, serves as a technical content creator in the ExcelDemy project. Possessing a passion for innovation and critical thinking, she actively embraces challenges. Beyond her engineering background, Afia exhibits a keen interest in Excel, having authored numerous articles on Excel & VBA-related issues to simplify the experience for users facing obstacles in Excel. Apart from creating Excel tutorials, she is also... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo