How to determine following function in Excel?
Hi Eric:
In B2 enter =A1+A2
and copy B2 down thru B9. You should see:
100
101 201
-50 51
-60 -110
50 -10
-50 0
-20 -70
-10 -30
80 70
In an un-used cell enter =MIN(B2:B9)
--
Gary's Student
"Eric" wrote:
I would like to set following conditions in Excel, but find it difficult on
coding.
Could anyone give me any suggestion please?
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
Does anyone have any suggestion?
Thank you in advance
Eric
|