Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 . |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|