Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Calculate Rate of Change Formula
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? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Calculate Rate of Change Formula
Hi Zee,
If your data is in a1 to a9, in b2 try: =(A2-A1)/ABS(A1) copied down to b9, and b2 to b9 formatted as %. Hope that helps, Anthony "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? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Calculate Rate of Change Formula
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? |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Calculate Rate of Change Formula
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? |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Calculate Rate of Change Formula
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) |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Calculate Rate of Change Formula
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel formula to calculate % gain when adding cash equity to accou | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
What formula do I use to calculate compound annual growth rate (C. | Excel Discussion (Misc queries) | |||
Cannot change a formula | Excel Discussion (Misc queries) |