**- Worldstart's Tech Tips And Computer Help - http://www.worldstart.com -**

Exponents in Excel

Posted By __ On December 31, 2009 @ 9:44 AM In ____MS Excel__ | __Comments Disabled__

Have you ever needed to use exponents in an MS Excel formula, but you didn’t know how?

I mean, maybe you need to square the value of a cell or something similar.

Either way, wouldn’t it be nice to know how to enter the power properly? You know, so you can avoid the whole multiplying the same number over and over in your formula kind of thing.

Well, to tell you the truth, there are a couple of ways to accomplish your goal.

Let’s say you need to enter six to the third power.

The first way you can enter the power is:

**=6^3**

The first number is the base and the second is the exponent.

The second option would be the formula of:

**=Power(6,3)**

Again, the first number is the base and the second is the exponent.

The numbers could also be replaced by cell references, which really gives you a flexible formula.

Here’s to “Excel-ing” in flexibility!

~April

I mean, maybe you need to square the value of a cell or something similar.

Either way, wouldn’t it be nice to know how to enter the power properly? You know, so you can avoid the whole multiplying the same number over and over in your formula kind of thing.

Well, to tell you the truth, there are a couple of ways to accomplish your goal.

Let’s say you need to enter six to the third power.

The first way you can enter the power is:

The second option would be the formula of:

The numbers could also be replaced by cell references, which really gives you a flexible formula.

Here’s to “Excel-ing” in flexibility!

~April

Article printed from Worldstart's Tech Tips And Computer Help: **http://www.worldstart.com**

URL to article: **http://www.worldstart.com/exponents-in-excel/**

Click here to print.