Calculate Rate of Change Formula
 

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?

Calculate Rate of Change Formula
 

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:

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?

Calculate Rate of Change Formula
 

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?

Calculate Rate of Change Formula
 

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?

Calculate Rate of Change Formula
 

On Thu, 28 Sep 2006 02:14:02 +0100, Zee
wrote:

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?

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
=(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?




--
Steve (3)

Calculate Rate of Change Formula
 

+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:

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?

Calculate Rate of Change Formula
 

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:

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?