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?