 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / September 2006Calculate 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? 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 > Hi > [quoted text clipped - 23 lines] > > So what should the formula be? If the numbers are in A1:A9, are you looking for =(A2-A1)/ABS(A1) > Hi > [quoted text clipped - 23 lines] > > So what should the formula be? 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 > If the numbers are in A1:A9, are you looking for > =(A2-A1)/ABS(A1) [quoted text clipped - 26 lines] > > > > So what should the formula be? > Thanks Anthony & JMB > Below are results,but a Q on them [quoted text clipped - 12 lines] > 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 [quoted text clipped - 35 lines] >> > >> > So what should the formula be?  SignatureSteve (3) +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. > Thanks Anthony & JMB > Below are results,but a Q on them [quoted text clipped - 46 lines] > > > > > > So what should the formula be? 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) > Hi > [quoted text clipped - 23 lines] > > So what should the formula be?
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.