
Tip #3891 - Exponents in Excel
Printer Friendly Version | E-Mail This Tip
Exponents
in Excel
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 flexibility!
~ April
Want To Comment On This Tip? Click Here! We'd love to hear from you :-)
Like These Tips? Get 'Em Free In Your E-mail