Attached please find the sheet attached.
In sheet Fidler1 Column A is just random number of 1 and 0. (You will have to redo the random number between 1 and 0 as I have done a copy paste values)
I am trying to come up with a formula that will handle Fidler2, Column G's issue of trying to increase by 1.25 if the previous value was positive or decrease by .1 (multiply by .9) if the previous value was negative. Column "C" denotes whether the number was up or down represented by a "1" or "-1".
Column "I" is a manual representation of how this would work if it were coded in vba or with excel formula in the best case scenario.
Also, if the value becomes greater than 1000 I would like to reset it to 125.
If the value becomes less than 25 I would like to reset it to 50
Any ideas how this might look? thanks!