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:
The first number is the base and the second is the exponent.
The second option would be the formula of:
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!