{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Fonction Si()","Fonctions Si() imbriquées"],"not_rendered":{"images":12,"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"Fonction Si()","index":0,"n_rows":29,"n_cols":18,"rows_kept":29,"merged":[[1,5,1,15],[3,5,3,6],[5,13,6,13],[6,15,7,15],[7,13,8,13],[8,17,9,17],[8,18,9,18],[9,13,10,13],[10,15,11,15],[11,13,12,13],[16,5,17,16]]}
[]
[{"$nulls":5},"C O U P E   D U   M O N D E   2 0 2 2"]
[]
[{"$nulls":4},"PAYS 1","Buts",null,"PAYS 2",{"$nulls":3},"VAINQUEUR"]
[]
[{"$nulls":4},"Brésil",2,1,"Chili",null,{"$f":"\"->\"","v":"->"},{"$nulls":3},{"$f":"N23","v":0}]
[{"$nulls":4},"Uruguay",5,0,"Colombie",null,{"$f":"\"->\"","v":"->"},{"$nulls":5},{"$f":"P24","v":0}]
[{"$nulls":4},"France",4,3,"Nigéria",null,"->",{"$nulls":3},{"$f":"N24","v":0}]
[{"$nulls":4},"Allemagne",3,4,"Algérie",null,"->",{"$nulls":7},{"$f":"R25","v":0}]
[{"$nulls":4},"Mexique",5,0,"Pays-bas",null,"->",{"$nulls":3},{"$f":"N25","v":0}]
[{"$nulls":4},"Grèce",2,4,"Costa Rica",null,"->",{"$nulls":5},{"$f":"P25","v":0}]
[{"$nulls":4},"Argentine",1,4,"Suisse",null,"->",{"$nulls":3},{"$f":"N26","v":0}]
[{"$nulls":4},"Belgique",2,5,"Etats-unis",null,"->"]
[]
[]
[]
[{"$nulls":5},"Utiliser la fonction Si() pour obtenir, dans les cellules blanches, le nom du pays vainqueur de chacun des matchs de 8ème de finale."]
[]
[]
[]
[{"$nulls":12},{"$f":"SUM(M22:M29)","v":8}]
[{"$nulls":11},{"$f":"IF(F6>G6,E6,H6)","v":"Brésil"},{"$f":"IF(L6=L22,0,1)","v":1}]
[{"$nulls":11},{"$f":"IF(F7>G7,E7,H7)","v":"Uruguay"},{"$f":"IF(L7=L23,0,1)","v":1},{"$f":"INDEX(L6:L7,RANDBETWEEN(1,2))","v":0}]
[{"$nulls":11},"France",1,{"$f":"INDEX(L8:L9,RANDBETWEEN(1,2))","v":0},null,{"$f":"INDEX(N23:N24,RANDBETWEEN(1,2))","v":0}]
[{"$nulls":11},"Algérie",1,{"$f":"INDEX(L10:L11,RANDBETWEEN(1,2))","v":0},null,{"$f":"INDEX(N25:N26,RANDBETWEEN(1,2))","v":0},null,{"$f":"INDEX(P24:P25,RANDBETWEEN(1,2))","v":0}]
[{"$nulls":11},"Mexique",1,{"$f":"INDEX(L12:L13,RANDBETWEEN(1,2))","v":0}]
[{"$nulls":11},"Costa Rica",1]
[{"$nulls":11},"Suisse",1]
[{"$nulls":11},"Etats-unis",1]

{"sheet":"Fonctions Si() imbriquées","index":1,"n_rows":57,"n_cols":17,"rows_kept":57,"merged":[[1,3,1,12],[3,4,3,5],[3,12,3,13],[6,1,25,1],[8,15,8,18],[9,15,10,18],[11,15,12,18]]}
[]
[{"$nulls":3},"QUALIFICATIONS EN CHAMPIONNAT"]
[]
[{"$nulls":3},"Domicile","Buts",null,"Visiteur",{"$nulls":3},"VAINQUEUR/égalité",null,"Points obtenus"]
[{"$nulls":12},"Domicile","Visiteur"]
[]
[null,"Utiliser la fonction Si() pour obtenir, dans les cellules blanches, le nom du pays vainqueur de chacun des matchs de qualification. Écrire \"égalité\" en cas d'égalité !\nCalculer également le nombre de points obtenus par chaque équipe et pour chaque match. Gagnant : 3 pts, égalité : 1pt, perdant : 0 pt.",null,"Danemark",0,1,"Serbie",null,{"$f":"\"->\"","v":"->"}]
[{"$nulls":3},"Arménie",0,4,"Serbie",null,{"$f":"\"->\"","v":"->"}]
[{"$nulls":3},"Arménie",3,3,"Albanie",null,"->",{"$nulls":6},"Qualifiés :"]
[{"$nulls":3},"Albanie",1,2,"Arménie",null,"->",{"$nulls":6},{"$f":"Q31","v":""}]
[{"$nulls":3},"Danemark",4,4,"Portugal",null,"->"]
[{"$nulls":3},"Danemark",2,5,"Arménie",null,"->",{"$nulls":6},{"$f":"Q32","v":""}]
[{"$nulls":3},"Portugal",4,0,"Danemark",null,{"$f":"\"->\"","v":"->"}]
[{"$nulls":3},"Portugal",3,4,"Albanie",null,{"$f":"\"->\"","v":"->"}]
[{"$nulls":3},"Serbie",0,2,"Danemark",null,"->"]
[{"$nulls":3},"Portugal",2,1,"Serbie",null,"->"]
[{"$nulls":3},"Albanie",5,4,"Danemark",null,"->"]
[{"$nulls":3},"Serbie",4,2,"Portugal",null,"->"]
[{"$nulls":3},"Danemark",4,1,"Albanie",null,{"$f":"\"->\"","v":"->"}]
[{"$nulls":3},"Arménie",2,2,"Portugal",null,{"$f":"\"->\"","v":"->"}]
[{"$nulls":3},"Albanie",5,0,"Portugal",null,"->"]
[{"$nulls":3},"Arménie",3,2,"Danemark",null,"->"]
[{"$nulls":3},"Serbie",0,1,"Arménie",null,"->"]
[{"$nulls":3},"Portugal",0,2,"Arménie",null,"->"]
[{"$nulls":3},"Serbie",5,3,"Albanie",null,{"$f":"\"->\"","v":"->"}]
[{"$nulls":3},"Albanie",2,5,"Serbie",null,"->"]
[]
[]
[]
[null,{"$f":"IF(C30=20,1,0)","v":0},{"$f":"SUM(C31:C50)","v":0}]
[null,{"$f":"IF(E7>F7,D7,IF(E7=F7,\"égalité\",G7))","v":"Serbie"},{"$f":"IF(K7=B31,1,0)","v":0},"Danemark",{"$f":"IF(E7>F7,3,IF(E7<F7,0,1))","v":0},null,"Serbie",null,{"$f":"IF(E7>F7,0,IF(E7<F7,3,1))","v":3},null,null,{"$f":"RANK(N31,N$31:N$35)","v":1},"Danemark",{"$f":"SUMIF(G$31:G$50,M31,E$31:E$50)+SUMIF(D$31:D$50,M31,I$31:I$50)","v":16},null,null,{"$f":"IF(AND(B30=1,M37=1,N37=1),VLOOKUP(1,L31:M35,2,0),\"\")","v":""}]
[null,{"$f":"IF(E8>F8,D8,IF(E8=F8,\"égalité\",G8))","v":"Serbie"},{"$f":"IF(K8=B32,1,0)","v":0},"Arménie",{"$f":"IF(E8>F8,3,IF(E8<F8,0,1))","v":0},null,"Serbie",null,{"$f":"IF(E8>F8,0,IF(E8<F8,3,1))","v":3},null,null,{"$f":"RANK(N32,N$31:N$35)","v":5},"Arménie",{"$f":"SUMIF(G$31:G$50,M32,E$31:E$50)+SUMIF(D$31:D$50,M32,I$31:I$50)","v":5},null,null,{"$f":"IF(AND(B30=1,M37=1,N37=1),VLOOKUP(2,L31:M35,2,0),\"\")","v":""}]
[null,"égalité",0,"Arménie",1,null,"Albanie",null,1,null,null,3,"Albanie",13]
[null,"Arménie",0,"Albanie",0,null,"Arménie",null,3,null,null,2,"Portugal",14]
[null,"égalité",0,"Danemark",1,null,"Portugal",null,1,null,null,4,"Serbie",9]
[null,"Arménie",0,"Danemark",0,null,"Arménie",null,3]
[null,"Portugal",0,"Portugal",3,null,"Danemark",null,0,{"$nulls":3},{"$f":"IF(SUM(M38:M57)=20,1,0)","v":0},{"$f":"IF(SUM(N38:N57)=20,1,0)","v":0}]
[null,"Albanie",0,"Portugal",0,null,"Albanie",null,3,{"$nulls":3},{"$f":"IF(E31=M7,1,0)","v":1},{"$f":"IF(N7=I31,1,0)","v":0}]
[null,"Danemark",0,"Serbie",0,null,"Danemark",null,3,{"$nulls":3},{"$f":"IF(E32=M8,1,0)","v":1},{"$f":"IF(N8=I32,1,0)","v":0}]
[null,"Portugal",0,"Portugal",3,null,"Serbie",null,0,{"$nulls":3},0,0]
[null,"Albanie",0,"Albanie",3,null,"Danemark",null,0,{"$nulls":3},1,0]
[null,"Serbie",0,"Serbie",3,null,"Portugal",null,0,{"$nulls":3},0,0]
[null,"Danemark",0,"Danemark",3,null,"Albanie",null,0,{"$nulls":3},1,0]
[null,"égalité",0,"Arménie",1,null,"Portugal",null,1,{"$nulls":3},0,1]
[null,"Albanie",0,"Albanie",3,null,"Portugal",null,0,{"$nulls":3},1,0]
[null,"Arménie",0,"Arménie",3,null,"Danemark",null,0,{"$nulls":3},1,0]
[null,"Arménie",0,"Serbie",0,null,"Arménie",null,3,{"$nulls":3},0,1]
[null,"Arménie",0,"Portugal",0,null,"Arménie",null,3,{"$nulls":3},0,1]
[null,"Serbie",0,"Serbie",3,null,"Albanie",null,0,{"$nulls":3},0,1]
[null,"Serbie",0,"Albanie",0,null,"Serbie",null,3,{"$nulls":3},0,1]
[{"$nulls":12},0,0]
[{"$nulls":12},0,1]
[{"$nulls":12},0,1]
[{"$nulls":12},1,0]
[{"$nulls":12},{"$f":"IF(E48=M24,1,0)","v":1},0]
[{"$nulls":12},0,1]
[{"$nulls":12},1,0]