Need a Formula , please help

  • Thread starter Thread starter ytayta555
  • Start date Start date
Y

ytayta555

Hi to everybody

Here we have this kind of data in column F11:F35

Col F Col G

1 1
1 2
1 3
1 4
-1 0
-1 0
1 1
1 2
1 3
1 4
-1 0
-1 0
1 1
1 2
1 3
1 4
1 5
1 6
-1 0
-1 0
-1 0
-1 0
-1 0
1 1
1 2

In column G are the results of a formula ,
which is the next :

=IF(AND(F11=F$11,F$11=1),G10+1,)

It give the right results when the value in column
F is 1 ; when is negative , ( -1 ) , this formula didn't give
the results we need ; we need so :

1 1
1 2
1 3
1 4
-1 -1
-1 -2
1 1
1 2
1 3
1 4
-1 -1
-1 -2
-1 -3
1 2
1 3
1 4
1 5
1 6
-1 -1
-1 -2
-1 -3
-1 -4
-1 -5
1 1
1 2

Thank you very much , have a great day .
 
Please for excuse , I didn't know that
the answer was gived already in programming ,
by ker_01

=IF(F11*G10>0;F11+G10;F11)

......

Many thanks , have a great week-end .
 
Back
Top