Calculate Rate of Change Formula Zee 27.09.2006 23:14:02 Hi Could someone help me w/the rate of chage formula to use when going from a Negative to a Positive number and visa versa In the column below - and + #s followinf each other So what formula should I use to figure out ROC between 1 & 2, then between 2 & 3, then 3 & 4 espicially between 4 & 5, and 8 & 9, when it changes signs -0.0021 -0.0007 -0.0009 -0.0004 0.0001 0.0036 0.0028 0.0023 -0.0009 Would have IF and statements? Because sometime neg follows neg, then neg follows positive, then poistive follws negative So what should the formula be?

RE: Calculate Rate of Change Formula Anthony D 28.09.2006 00:30:02 Hi Zee, If your data is in a1 to a9, in b2 try: =(A2-A1)/ABS(A1) copied down to b9, and b2 to b9 formatted as %. Hope that helps, Anthony "Zee" wrote: [Quoted Text] > Hi > > Could someone help me w/the rate of chage formula to use when going from a > Negative to a Positive number and visa versa > > In the column below - and + #s followinf each other > > So what formula should I use to figure out ROC between 1 & 2, then between > 2 & 3, then 3 & 4 espicially between 4 & 5, and 8 & 9, when it changes > signs > > -0.0021 > -0.0007 > -0.0009 > -0.0004 > 0.0001 > 0.0036 > 0.0028 > 0.0023 > -0.0009 > > Would have IF and statements? > > Because sometime neg follows neg, then neg follows positive, then poistive > follws negative > > So what should the formula be? >

RE: Calculate Rate of Change Formula JMB 28.09.2006 00:35:02 If the numbers are in A1:A9, are you looking for =(A2-A1)/ABS(A1) "Zee" wrote: [Quoted Text] > Hi > > Could someone help me w/the rate of chage formula to use when going from a > Negative to a Positive number and visa versa > > In the column below - and + #s followinf each other > > So what formula should I use to figure out ROC between 1 & 2, then between > 2 & 3, then 3 & 4 espicially between 4 & 5, and 8 & 9, when it changes > signs > > -0.0021 > -0.0007 > -0.0009 > -0.0004 > 0.0001 > 0.0036 > 0.0028 > 0.0023 > -0.0009 > > Would have IF and statements? > > Because sometime neg follows neg, then neg follows positive, then poistive > follws negative > > So what should the formula be? >

RE: Calculate Rate of Change Formula Zee 28.09.2006 01:14:02 Thanks Anthony & JMB Below are results,but a Q on them Result -0.0021 38 -0.0007 67 -0.0009 -29 -0.0004 56 0.0001 125 0.0036 3500 0.0028 -22 0.0023 -18 -0.0009 -139 Why am I getting +67 between two neg #s, and -29 again between 2 neg #s? Please help Thanks Zee "JMB" wrote: [Quoted Text] > If the numbers are in A1:A9, are you looking for > =(A2-A1)/ABS(A1) > > > > "Zee" wrote: > > > Hi > > > > Could someone help me w/the rate of chage formula to use when going from a > > Negative to a Positive number and visa versa > > > > In the column below - and + #s followinf each other > > > > So what formula should I use to figure out ROC between 1 & 2, then between > > 2 & 3, then 3 & 4 espicially between 4 & 5, and 8 & 9, when it changes > > signs > > > > -0.0021 > > -0.0007 > > -0.0009 > > -0.0004 > > 0.0001 > > 0.0036 > > 0.0028 > > 0.0023 > > -0.0009 > > > > Would have IF and statements? > > > > Because sometime neg follows neg, then neg follows positive, then poistive > > follws negative > > > > So what should the formula be? > >

Re: Calculate Rate of Change Formula SteveW <sj_walton[ at ]nothotmail.com> 28.09.2006 01:28:31 On Thu, 28 Sep 2006 02:14:02 +0100, Zee <Zee[ at ]discussions.microsoft.com> = = wrote: [Quoted Text] > Thanks Anthony & JMB > Below are results,but a Q on them > > Result > -0.0021 38 > -0.0007 67 > -0.0009 -29 > -0.0004 56 > 0.0001 125 > 0.0036 3500 > 0.0028 -22 > 0.0023 -18 > -0.0009 -139 > > Why am I getting +67 between two neg #s, and -29 again between 2 ne= g = > #s? because it went from -.0021 to -0.0007 ie increase of 67% in the other one it drops from -.0007 to -0.0009 ie a drop of 29% Don't blame the formula if the answers aren't what you expected :) Seriously, though always good to query the results - it might be a data = = error or one in the formula - always best to check. You haven't explained what the data is, but as long as the values are = equally spaced in time or whatever then the results shuold be valid. > Please help > Thanks > Zee > = > > > "JMB" wrote: > >> If the numbers are in A1:A9, are you looking for >> =3D(A2-A1)/ABS(A1) >> >> >> >> "Zee" wrote: >> >> > Hi >> > >> > Could someone help me w/the rate of chage formula to use when goin= g = >> from a >> > Negative to a Positive number and visa versa >> > >> > In the column below - and + #s followinf each other >> > >> > So what formula should I use to figure out ROC between 1 & 2, then= = >> between >> > 2 & 3, then 3 & 4 espicially between 4 & 5, and 8 & 9, when it = >> changes >> > signs >> > >> > -0.0021 >> > -0.0007 >> > -0.0009 >> > -0.0004 >> > 0.0001 >> > 0.0036 >> > 0.0028 >> > 0.0023 >> > -0.0009 >> > >> > Would have IF and statements? >> > >> > Because sometime neg follows neg, then neg follows positive, then = = >> poistive >> > follws negative >> > >> > So what should the formula be? >> > -- = Steve (3)

RE: Calculate Rate of Change Formula JMB 28.09.2006 01:30:01 +67: Because -0.0007 is larger than -0.0021 -29: Because -0.0009 is smaller than -0.0007 Positive rate of change means the numbers are getting larger, negative means the numbers are getting smaller. "Zee" wrote: [Quoted Text] > Thanks Anthony & JMB > Below are results,but a Q on them > > Result > -0.0021 38 > -0.0007 67 > -0.0009 -29 > -0.0004 56 > 0.0001 125 > 0.0036 3500 > 0.0028 -22 > 0.0023 -18 > -0.0009 -139 > > Why am I getting +67 between two neg #s, and -29 again between 2 neg #s? > Please help > Thanks > Zee > > > > "JMB" wrote: > > > If the numbers are in A1:A9, are you looking for > > =(A2-A1)/ABS(A1) > > > > > > > > "Zee" wrote: > > > > > Hi > > > > > > Could someone help me w/the rate of chage formula to use when going from a > > > Negative to a Positive number and visa versa > > > > > > In the column below - and + #s followinf each other > > > > > > So what formula should I use to figure out ROC between 1 & 2, then between > > > 2 & 3, then 3 & 4 espicially between 4 & 5, and 8 & 9, when it changes > > > signs > > > > > > -0.0021 > > > -0.0007 > > > -0.0009 > > > -0.0004 > > > 0.0001 > > > 0.0036 > > > 0.0028 > > > 0.0023 > > > -0.0009 > > > > > > Would have IF and statements? > > > > > > Because sometime neg follows neg, then neg follows positive, then poistive > > > follws negative > > > > > > So what should the formula be? > > >

RE: Calculate Rate of Change Formula Rookie 1st class 29.09.2006 17:03:02 If the correct answer for the first 2 numbers is 14, Copy this formula into the cell to the right of -0.0007 and then fill down. If -0.0021 is not in (A1) you will need to adjust the formula. ABS doesn't care whether negative or positive numbers. =ABS(A1-A2) "Zee" wrote: [Quoted Text] > Hi > > Could someone help me w/the rate of chage formula to use when going from a > Negative to a Positive number and visa versa > > In the column below - and + #s followinf each other > > So what formula should I use to figure out ROC between 1 & 2, then between > 2 & 3, then 3 & 4 espicially between 4 & 5, and 8 & 9, when it changes > signs > > -0.0021 > -0.0007 > -0.0009 > -0.0004 > 0.0001 > 0.0036 > 0.0028 > 0.0023 > -0.0009 > > Would have IF and statements? > > Because sometime neg follows neg, then neg follows positive, then poistive > follws negative > > So what should the formula be? >