Results 1 to 7 of 7
Thread: ^ in a formula (XP & 2003)

20081112, 07:15 #1
 Join Date
 Jun 2005
 Posts
 394
 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.

20081112, 07:21 #2
 Join Date
 Mar 2002
 Posts
 84,353
 Thanks
 0
 Thanked 30 Times in 30 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).

20081112, 07:57 #3
 Join Date
 Jun 2005
 Posts
 394
 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

20081112, 08:10 #4
 Join Date
 Mar 2002
 Posts
 84,353
 Thanks
 0
 Thanked 30 Times in 30 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

20081112, 08:14 #5
 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

20081112, 09:15 #6
 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

20081113, 00:36 #7
 Join Date
 Jun 2005
 Posts
 394
 Thanks
 3
 Thanked 0 Times in 0 Posts
Re: ^ in a formula (XP & 2003)
Thank you  all