Results 1 to 7 of 7
  1. #1
    3 Star Lounger
    Join Date
    Jun 2005
    Posts
    388
    Thanks
    3
    Thanked 0 Times in 0 Posts

    ^ in a formula (XP & 2003)

    I ran across a formula as follows "+246*(1+.15)^5*200" . What function does the ^ perform in the formula? I never saw it used before.

    Thank you.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: ^ in a formula (XP & 2003)

    ^ means "to the power of". For example 3^2 means "3 to the power 2", conventionally written as 3 (which equals 3*3 = 9), and 2^3 means "2 to the power 3", conventionally written as 2 (which equals 2*2*2 = 8).

  3. #3
    3 Star Lounger
    Join Date
    Jun 2005
    Posts
    388
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: ^ in a formula (XP & 2003)

    Thanks for the primer in the use of ^ the exponent sign. However, I still cannot figure out the formula in the cell which reads{=246*(1+.15)^2*500} . Does this mean that the (246 *1.15) to the power of 2 and the product of this formula is 80,032.41. Then multiply the product of 80,032.41 by 500. Is this the order of calculation? However, the answer came out to 162,677.50.

    Also, Why does the formula have the { before and a }after the formula.

    As always, Thank you

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: ^ in a formula (XP & 2003)

    The power operator ^ has precedence above the muliplication operator *, so in your formula, (1+.15)^2 is calculated first, and the result 1.3225 is multiplied with both 246 and 500, giving 162,677.5

  5. #5
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ^ in a formula (XP & 2003)

    Broken out it is
    1.15 * 246 * 500 =
    1.3225 * 246 * 500 =
    1.3225 * 123000 =
    162667.5

    The { } indicates it was entered as an array formula Crtl+Shift+Enter to confirm the formula instead of just Enter

    This
    <hr>(246 *1.15) to the power of 2 ... multiply ... by 500<hr>
    would be
    =(246*1.15)^2 * 500

  6. #6
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: ^ in a formula (XP & 2003)

    <hr>Why does the formula have the { before and a }after the formula<hr>
    The squiggly brackets are indicative of an array formula. A primer on array formulas can be found on Chip Pearson's website.
    Regards
    Don

  7. #7
    3 Star Lounger
    Join Date
    Jun 2005
    Posts
    388
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: ^ in a formula (XP & 2003)

    Thank you - all

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •