Option Explicit
Sub MiseEnPlaceFormules()
With Feuil1.[F4:G13]
.Columns(1).FormulaR1C1 = "=IF(RC3=""Licence"",0.25*RC4+0.75*RC5,0.35*RC4+0.65*RC5)"
.Columns(2).FormulaR1C1 = "=INDEX({""Ajourné"";""Assez Bien"";""Bien"";""Très Bien""},MATCH(RC6,{0;10;12;16}))"
.Offset(, 2).Value = .Value
End With
End Sub