Need a Formula , please help

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 .
 
Y

ytayta555

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 .
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top