Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |