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