Formula to Calculate Rate of Change in Microsoft Excel

[Lanka Boy]

Could someone help me for the rate of exchange formula to use when going from a Negative to a Positive number and vice versa? In the column below - and + #s following each other. So what formula should I use to figure out ROC between 1 & 2, then between 2 & 3, then 3 & 4 especially 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 negative number follows negative number, then negative number follows positive number, then positive number follows negative number. So what should the formula be?

[JustineBB]

According to my suggestion If your data is in a1 to a9, in b2 try: this formula = (A2-A1)/ABS (A1) and copied down to b9, and b2 to b9 formatted as %. This will works for this topic.

[BillieJ]

This is simple to do this thing in Excel so for that you just try this formula there in the Excel sheet. If the numbers are in A1:A9, are you looking for =(A2-A1)/ABS (A1)