Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
I posted a message earlier and have received a partial solution.
I want to keep track of how much stock prices go up or down with a running total of how much they go up or down over several days until the direction changes. The formula I am now using total the first and second day but does not do a running total count if there are more than two up or down days in a row. Your help is appreciated. =IF(SIGN(H3)=SIGN(H4),H3+H4,H3) However, the example below illustrates what I am looking for ---- column A are the daily totals and column B is an example of how I want to calculate the running total: A B Row 1 10 10 2 10 20 3 10 30 4 -5 -5 5 -5 -10 6 -5 -15 7 10 10 8 20 30 9 30 60 10 -5 -5 11 15 15 12 15 30 When the number is column A changes from positive to negative or negative back to positive, I want to adjust column B until it changes again. Is this possible? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Convert a column of numbers from positive to negative in Excel | Excel Discussion (Misc queries) | |||
Indian comma in excel in positive numbers as well as in negative | Excel Discussion (Misc queries) | |||
how to interchange positive to negative value in excel | Excel Discussion (Misc queries) | |||
how to turn positive to negative values in excel | Excel Worksheet Functions | |||
Formula to make Negative Values Positive & Positive Values Negative? | Excel Discussion (Misc queries) |