Solution EX SI
1- =MOYENNE(B2:E2)
2- =SI(OU(B2<=7;C2<=7;D2<=7;E2<=7);"Non";"Oui")
3- =NB.SI(G2:G21;"oui")
4- =MOYENNE.SI(G2:G21;"oui";F2:F21)
Modifié le: Monday 20 February 2023, 20:09
1- =MOYENNE(B2:E2)
2- =SI(OU(B2<=7;C2<=7;D2<=7;E2<=7);"Non";"Oui")
3- =NB.SI(G2:G21;"oui")
4- =MOYENNE.SI(G2:G21;"oui";F2:F21)