Need a Formula , please help
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 . |
Need a Formula , please help
On 23 Iul, 03:00, ytayta555 wrote:
Please for excuse , I didn't know that the answer was gived already in programming , by ker_01 =IF(F11*G100;F11+G10;F11) ...... Many thanks , have a great week-end . |
All times are GMT +1. The time now is 07:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com