Exponents are merely duplicated reproductions. Four to the third power (4 ³ )isn’t 4 x 3, it’s 4 x 4 x 4, which equates to a total of 64. If that sounds complicated, fear not; Excel can do the heavy lifting for you!

How to Display Exponents in Excel

Before we discover how to use exponents, we’ll begin with a fast example of how to type them in Excel. In this case, we’ll require to use the Superscript function, so we can display the exponent.

To do this, right-click an empty cell, and after that choose “Format Cells” from the menu.

Under “Category:” left wing, select “Text,” and then click “OK.”

In the same cell, type both the base number and exponent with no areas between them. In our example, we’re going to discover 10 ³ (10 x 10 x 10). Our base number is 10 and three is the exponent.

Next, highlight your exponent; in our example, it’s the 3.

Right-click the cell again, and then pick “Format Cells.”

Select the checkbox beside “Superscript” in the “Effects” area, and then click “OK.” Press Enter or click in any other cell to complete the process.

How to Use Exponents in the Formula Bar

You can also utilize exponents in the Excel Formula bar. To do so, click the empty cell where you ‘d like to show the result of an estimation.

You plug your exponent into the following formula: “=Power(number, power).” We’ll utilize 10 ⁴ for our example, so we type “=Power(10,4)” (without the quotation marks) in the formula bar.

To carry out the formula, press Enter or click the checkmark to the left of the formula bar.

How to Use Exponents in an Individual Cell

If you want to perform the calculation inside a cell, you can skip the formula bar totally and utilize a little Excel shorthand, rather.

To discover 10 ⁵, for example, you could type “=10 ^ 5” (again, without the quote marks), and then press Enter.

Regardless of how you get there, the response will be the same. If you’re brief on time, discovering the service to an exponent in Excel is a quick alternative to manual estimations.

Prior to we learn how to use exponents, we’ll start with a fast example of how to type them in Excel. In the same cell, type both the base number and exponent without any areas between them. You can likewise use exponents in the Excel Formula bar. Regardless of how you get there, the response will be the same.