Function Calcul(Plage As Range)
On Error GoTo Fin2: T = Plage
For i = 1 To UBound(T, 2)
If Not IsNumeric(T(1, i)) Or T(1, i) > 9 Then T(1, i) = 11
Next i
Calcul = (5 * (11 - T(1, 1)) + 4 * (11 - T(1, 2)) + 3 * (11 - 10) + 2 * (11 - T(1, 4))) / 4
Fin2:
End Function