# How to Use Negative Exponents in Excel – 3 Methods

In the following dataset, you can see the Base and Exponent columns. The Exponent column has negative exponents.

### Method 1 – Using Keyboard Shortcuts to Use Negative Exponents in Excel

Steps:

• Enter the following formula in D5.
`=B5^C5`

After =B5, use SHIFT+6 to display ^ and enter C5.

• Press ENTER.

You can see the result in D5.

• Drag down the Fill Handle to see the result in the rest of the cells.

This is the output.

### Method 2 – Using the POWER Function in Excel

Steps:

• Enter the following formula in D5.
`=POWER(B5,C5)`

Formula Breakdown

• POWER(B5,C5) →  returns the outcome of a number raised to a power.
• B5 is the number.
• C5 → is the power.
• Outcome: 0.25

25 is the result of 2 raised to -2.

• Press ENTER.

You can see the result in D5.

• Drag down the Fill Handle to see the result in the rest of the cells.

This is the output.

### Method 3 – Applying the EXP Function to use Negative Exponents

Find the negative exponent of base e:

Steps:

• Enter the following formula in D5.
`=EXP(C5)`

Formula Breakdown

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

You can see the result in D5.

• Drag down the Fill Handle to see the result in the rest of the cells.

This is the output.

## How to Use Positive Exponents in Excel

Steps:

• Enter the following formula in 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

4 is the result of 2 raised to 2.

• Press ENTER.

You can see the result in D5.

• Drag down the Fill Handle to see the result in the rest of the cells.

This is the output.

Practice here.

## Related Articles

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

Get FREE Advanced Excel Exercises with Solutions!
Afia Kona

Afia Aziz Kona, a graduate of NAME from Bangladesh 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 interested... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF