E^2 in excel

Facebook0Tweet0LinkedIn0Email0

Exponents are a value that is applied to a number to determine how many times to multiply against itself.

4² for example means 4 x 4 = which would equal 16

5⁴ means 5 x 5 x 5 x 5 which would be 625

And so on.

It is a simple but powerful mathematical method that can be achieved in Excel in a few different ways.

Outside of pure formatting, there are two key approaches that we can take to use Exponents.

In this simple guide, we are going to run through how to use Exponents in Excel. We will cover:

• Excel formatting of Exponents
• Using Exponents with POWER
• Using Exponents with ^

Before we move onto the formulas itself, let’s quickly discuss formatting.

Excel formatting of Exponents

There is also another approach worth discussing – and that is the formatting itself of Exponents.

To make the second number appear in the way it has above, small and sitting slightly higher, we need to use superscript formatting. We have a separate guide on how to achieve this here.

Now that we have covered off the basics of how to make visual Expo

how to compute exponent in excel

how to find exponent in excel