How to determine following function in Excel?
in B2
=IF(ROW()=2,IF(SIGN(A1)<SIGN(A2),A2,A1+A2),IF(SIG N(A1)<SIGN(A2),A2,A2+B1))
Then select b2 and drag down the column
in C1
=min(B:B)
--
Regards,
Tom Ogilvy
"Eric" wrote in message
...
Thank everyone for suggestion
Yes, I am interested on the consecutive loss sequences of any length, and
return the highest loss for the result.
Thank you
Eric
" wrote:
"Eric" wrote:
Under A Colume, there are a list of numbers
Profit
100
101
-50
-60
50
-50
-20
-10
80
Under Colume B, I would like to determine the maximum
consecutive loss from Colume A, in this case, it should
return -50-60 = -110
Clarification needed ....
For the 3 rows starting in the 4th row from the end, do
you want -50-20-10 = -80? And you would want that
to be the "maximum consecutive loss" if -60 were -20
in the 4th row (so that -50-20 = -70, not -110), right?
In other words, you are not just interested in pairwise
"consecutive" losses, but consecutive loss sequences of
any length. Is that right?
|