N
news
Hello,
I have this huge problem: I try to find a formula to obtain the following
result:
Let F15= 07/2002 and A2= 04/2002, A3= 05/2002, A4= 06/2002, A5=
07/2002, A6= 08/2002, ....A(x+1)=Ax +1month
C2 =SI (A2>=F15 ; P15 ; 0)
C3 =SI (A3>=F15 ; P15 ; 0)
C4 =SI (A4>=F15 ; P15 ; 0)
C5 =SI (A5>=F15 ; P15 ; 0) at this line, the condition
is obtained and for all the followings
C6 =SI (A6>=F15 ; P16 ; 0)
C7 =SI (A7>=F15 ; P17 ; 0)
C8 =SI (A8>=F15 ; P18 ; 0)
C9 =SI (A9>=F15 ; P19 ; 0)
In words : date value of cells "A" are fixed, but date of cell F15 is
variable, like results in "P" cells ; I would like to copy the column under
P15 on the "C "column, beginning at a line corresponding to equalization of
the date between F15 and "A" column.....
Is there someone who can help me...?
Patrick
I have this huge problem: I try to find a formula to obtain the following
result:
Let F15= 07/2002 and A2= 04/2002, A3= 05/2002, A4= 06/2002, A5=
07/2002, A6= 08/2002, ....A(x+1)=Ax +1month
C2 =SI (A2>=F15 ; P15 ; 0)
C3 =SI (A3>=F15 ; P15 ; 0)
C4 =SI (A4>=F15 ; P15 ; 0)
C5 =SI (A5>=F15 ; P15 ; 0) at this line, the condition
is obtained and for all the followings
C6 =SI (A6>=F15 ; P16 ; 0)
C7 =SI (A7>=F15 ; P17 ; 0)
C8 =SI (A8>=F15 ; P18 ; 0)
C9 =SI (A9>=F15 ; P19 ; 0)
In words : date value of cells "A" are fixed, but date of cell F15 is
variable, like results in "P" cells ; I would like to copy the column under
P15 on the "C "column, beginning at a line corresponding to equalization of
the date between F15 and "A" column.....
Is there someone who can help me...?
Patrick