=SIERREUR(SI(INDEX(JOBS!$A2:$U$559;PETITE.VALEUR(SI(CALCULATION!$L$3=JOBS!$A2:$A559;LIGNE(JOBS!$A2:$A559)-1);LIGNE()-2);EQUIV("CALENDARID";JOBS!$1:$1;0))<>"";"Along calendar";SI(INDEX(JOBS!$A2:$U$559;PETITE.VALEUR(SI(CALCULATION!$L$3=JOBS!$A2:$A559;LIGNE(JOBS!$A2:$A559)-1);LIGNE()-2);EQUIV("PRDMONTHS";JOBS!$1:$1;0))>0;"Every "&INDEX(JOBS!$A2:$U$559;PETITE.VALEUR(SI(CALCULATION!$L$3=JOBS!$A2:$A559;LIGNE(JOBS!$A2:$A559)-1);LIGNE()-2);EQUIV("PRDMONTHS";JOBS!$1:$1;0))&" month";"")&SI(INDEX(JOBS!$A2:$U$559;PETITE.VALEUR(SI(CALCULATION!$L$3=JOBS!$A2:$A559;LIGNE(JOBS!$A2:$A559)-1);LIGNE()-2);EQUIV("PRDWEEKS";JOBS!$1:$1;0))>0;"Every "&INDEX(JOBS!$A2:$U$559;PETITE.VALEUR(SI(CALCULATION!$L$3=JOBS!$A2:$A559;LIGNE(JOBS!$A2:$A559)-1);LIGNE()-2);EQUIV("PRDWEEKS";JOBS!$1:$1;0))&" weeks";"")&SI(INDEX(JOBS!$A2:$U$559;PETITE.VALEUR(SI(CALCULATION!$L$3=JOBS!$A2:$A559;LIGNE(JOBS!$A2:$A559)-1);LIGNE()-2);EQUIV("PRDDAYS";JOBS!$1:$1;0))>0;"Every "&INDEX(JOBS!$A2:$U$559;PETITE.VALEUR(SI(CALCULATION!$L$3=JOBS!$A2:$A559;LIGNE(JOBS!$A2:$A559)-1);LIGNE()-2);EQUIV("PRDDAYS";JOBS!$1:$1;0))&" days";"")&SI(INDEX(JOBS!$A2:$U$559;PETITE.VALEUR(SI(CALCULATION!$L$3=JOBS!$A2:$A559;LIGNE(JOBS!$A2:$A559)-1);LIGNE()-2);EQUIV("PRDHOURS";JOBS!$1:$1;0))>0;"Every "&INDEX(JOBS!$A2:$U$559;PETITE.VALEUR(SI(CALCULATION!$L$3=JOBS!$A2:$A559;LIGNE(JOBS!$A2:$A559)-1);LIGNE()-2);EQUIV("PRDHOURS";JOBS!$1:$1;0))&" hours";"")&SI(INDEX(JOBS!$A2:$U$559;PETITE.VALEUR(SI(CALCULATION!$L$3=JOBS!$A2:$A559;LIGNE(JOBS!$A2:$A559)-1);LIGNE()-2);EQUIV("PRDMINS";JOBS!$1:$1;0))>0;"Every "&INDEX(JOBS!$A2:$U$559;PETITE.VALEUR(SI(CALCULATION!$L$3=JOBS!$A2:$A559;LIGNE(JOBS!$A2:$A559)-1);LIGNE()-2);EQUIV("PRDMINS";JOBS!$1:$1;0))&" minutes";"")&SI(ET(I3=VRAI;NB.SI(DECALER(INDEX(JOBS!$A2:$U$559;PETITE.VALEUR(SI(CALCULATION!$L$3=JOBS!$A2:$A559;LIGNE(JOBS!$A2:$A559)-1);LIGNE()-2);1);;EQUIV("PRDMINS";JOBS!$1:$1;0)-1;;1+EQUIV("PRDMONTHS";JOBS!$1:$1;0)-EQUIV("PRDMINS";JOBS!$1:$1;0));">=1")=0);"Event";""));"")