Search Search for: Business ApplicationsAll Forums

# Calculating 'to the power of...' in Excel

 dmurfitt
Senior Member with 618 posts.

Join Date: Nov 2002
19-Oct-2005, 03:55 AM #1
Calculating 'to the power of...' in Excel
Hi,

I was wondering if someone could tell me how to calculate a formula in excel as, for example:

=A1+(B1*B2) And what I need is the brackets to be to the power of -1 or +1. Basically this is to calculate interest or inflation (depending if the power of 1 is + or -).

Thanks a lot,
Dan
 Yorkshire Guy
Member with 563 posts.

Join Date: Dec 2003
Location: Yorkshire, UK
19-Oct-2005, 05:26 AM #2
hi dmurgitt,

The character you want is the caret, like a little roof, on my keyboard it is shift + 6 (not numeric keys) along the top row.

So 5 to the power of 3 would be 5^3.

Anything to the power of 1 is the same, so why do you want that?

Cheers
Hew
 dmurfitt
Senior Member with 618 posts.

Join Date: Nov 2002
19-Oct-2005, 11:15 AM #3
Sorry I was just using an example. If it's a plus value it calculates interest, if it's minus it calculates inflation (does that sound about right?).

Thanks a lot for your help mate,
Dan
Member with 3,072 posts.

Join Date: Aug 2005
19-Oct-2005, 12:54 PM #4
Actually, I don't think your statement was entirely accurate, hew.

x ^ 1 = x, that is correct. However, I'm pretty sure that x ^ -1 = (1 / x).

Uh, so, yeah, there really was no point to me bumping this thread. Gotta go...

chris.
 techguy.org/409090
As Seen On

WELCOME TO TECH SUPPORT GUY!

If you're not already familiar with forums, watch our Welcome Guide to get started.

Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

### Find the solution to your computer problem!

 Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)