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