How to Do Exponents in Excel on PC or Mac
How to Do Exponents in Excel on PC or Mac
This wikiHow teaches you how to use a formula to calculate a power exponent's exact numeric value in an Excel spreadsheet, using a computer.
Steps

Open Microsoft Excel on your computer. Find the Excel app in your Applications folder or on your Start menu, and open it.

Create a new spreadsheet. Click the New button to create a new, blank spreadsheet where you can enter formulas and make calculations. Alternatively, you can open a saved spreadsheet file and work on it.

Double-click an empty cell. Find an empty cell where you can make your calculations, and double-click on it to edit the cell's contents.

Type =POWER(base,power) into the empty cell. This formula will allow you to insert a base number and a power exponent, and see the result of the calculation.

Replace base with the base number you want to multiply. Delete "base" in the formula, and enter the number you want to multiply here.

Replace power with the exponent you want to apply. Delete "power" in the formula, and enter the power exponent you want to multiply your base number by. For example, if you want to calculate 5 to the power of 3 (5), your formula should look like =POWER(5,3).

Hit ↵ Enter or ⏎ Return on your keyboard. This will make the specified calculation, and show the result in the formula cell. If you're calculating 5, you'll now see 125 here, which equals the third power of 5, instead of the formula.

What's your reaction?

Comments

https://hapka.info/assets/images/user-avatar-s.jpg

0 comment

Write the first comment for this!