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)