1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

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

Discussion in 'Business Applications' started by dmurfitt, Oct 19, 2005.

Thread Status:
Not open for further replies.
Advertisement
  1. dmurfitt

    dmurfitt Thread Starter

    Joined:
    Nov 27, 2002
    Messages:
    618
    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
     
  2. Yorkshire Guy

    Yorkshire Guy

    Joined:
    Dec 9, 2003
    Messages:
    563
    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
     
  3. dmurfitt

    dmurfitt Thread Starter

    Joined:
    Nov 27, 2002
    Messages:
    618
    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
     
  4. cristobal03

    cristobal03

    Joined:
    Aug 5, 2005
    Messages:
    3,072
    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
As Seen On...

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.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/409090