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)
آخر تعديل: Monday، 20 February 2023، 8:09 PM
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)