=(NB.SI(B3;"V")+NB.SI(B3;"F"))*$B$1+SI(ESTNUM(B3);B3-$B$1;0)
=NB.SI(B3;"V")*7,8+NB.SI(B3;"F")*7,8+SI(ESTNUM(B3);SOMME(B3-$B$1))
SI(ESTNUM(B3);B3;NB.SI(B3;"V")*7,8+NB.SI(B3;"F")*7,8)-$B$1
=SIERREUR(SI(OU(B3="V";B3="F";B3="A";B3="E");$B$1;B3-$B$1);0)
=(NB.SI(B3:B9;"V")+NB.SI(B3:B9;"F")+NB.SI(B3:B9;"A")+NB.SI(B3:B9;"E"))*7.8+SOMME(B3:B9)
=SI(ESTNUM(B3);B3-B$1;0)