Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search

Advertisement

Business Applications Business Applications
Search Search
Search for:
Tech Support Guy > > >

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


(!)

dmurfitt's Avatar
dmurfitt dmurfitt is offline
Senior Member with 618 posts.
THREAD STARTER
 
Join Date: Nov 2002
19-Oct-2005, 02: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's Avatar
Yorkshire Guy Yorkshire Guy is offline
Member with 563 posts.
 
Join Date: Dec 2003
Location: Yorkshire, UK
19-Oct-2005, 04: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's Avatar
dmurfitt dmurfitt is offline
Senior Member with 618 posts.
THREAD STARTER
 
Join Date: Nov 2002
19-Oct-2005, 10: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
cristobal03's Avatar
Member with 3,072 posts.
 
Join Date: Aug 2005
Experience: Advanced
19-Oct-2005, 11:54 AM #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.
As Seen On

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine
WELCOME TO TECH SUPPORT GUY!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

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


(clock)
THIS THREAD HAS EXPIRED.
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)
 
Thread Tools


WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑

Content Relevant URLs by vBSEO 3.3.2