{"text_format":"2","workbook":"xlsx","n_sheets":4,"sheets":["Fonctions .SI","La fonction Si","Si Imbriqués 1","Si Imbriqués 2"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Fonctions .SI","index":0,"n_rows":17,"n_cols":15,"rows_kept":17,"cut":false,"hidden":false,"merged":[[16,7,16,8],[0,7,1,8],[6,7,8,8],[9,7,9,8],[13,7,15,8],[11,10,12,11],[11,13,12,14],[0,0,0,5],[0,10,0,11],[0,13,0,14],[2,7,2,8]]}
["VENTES OCTOBRE",{"$nulls":6},"Nombre d'articles \nvendus dont la quantité \ndépasse 500",null,null,"Total des ventes \npar article",null,null,"Total des quantités \npar date"]
["Date","Vendeur","Article","Q","PU","Total",{"$nulls":4},"Article","Total",null,"Dates","Total"]
["2001-10-03","Martin","écrous",1534,0.25,{"$f":"D3*E3","v":383.5},null,{"$f":"COUNTIF(D3:D17,\">500\")","v":8},null,null,"clous",{"$f":"SUMIF($C$3:$C$17,K3,$F$3:$F$17)","v":2692.63},null,"2001-10-03",{"$f":"SUMIF($A$3:$A$17,N3,$D$3:$D$17)","v":5575}]
["2001-10-03","Dupont","clous",1987,0.25,496.75,{"$nulls":4},"écrous",{"$f":"SUMIF($C$3:$C$17,K4,$F$3:$F$17)","v":1883.73},null,"2001-10-08",{"$f":"SUMIF($A$3:$A$17,N4,$D$3:$D$17)","v":2607}]
["2001-10-03","Martin","écrous",2054,0.25,513.5,{"$nulls":4},"pieux",1555.9099999999999,null,"2001-10-14",1485]
["2001-10-08","Lambert","pieux",654,0.35,228.89999999999998,{"$nulls":7},"2001-10-23",831]
["2001-10-08","Martin","écrous",951,0.25,237.75,null,"Nombre d'articles \nvendus dont le prix est \ninférieur à 0,30€",{"$nulls":5},"2001-10-27",402]
["2001-10-08","Martin","écrous",1002,0.25,250.5]
["2001-10-14","Lambert","pieux",396,0.35,138.6]
["2001-10-14","Dupont","clous",542,0.35,189.7,null,{"$f":"COUNTIF(E3:E17,\"<0,35\")","v":5}]
["2001-10-14","Lambert","pieux",547,0.35,191.45]
["2001-10-23","Martin","clous",187,3.72,695.64,{"$nulls":4},"Moyenne des ventes \npar article",null,null,"Moyenne des quantités\npar vendeur"]
["2001-10-23","Dupont","clous",322,0.35,112.69999999999999]
["2001-10-23","Lambert","clous",322,3.72,1197.8400000000001,null,"Nombre d'articles vendus \nà partir du 15 octobre 2001",null,null,"Article","Moyenne",null,"Vendeur","Moyenne"]
["2001-10-27","Dupont","pieux",123,3.72,457.56,{"$nulls":4},"clous",{"$f":"AVERAGEIF($C$3:$C$17,K15,$F$3:$F$17)","v":538.52600000000007},null,"Martin",{"$f":"AVERAGEIF($B$3:$B$17,N15,$D$3:$D$17)","v":1145.5999999999999}]
["2001-10-27","Lambert","écrous",134,3.72,498.48,{"$nulls":4},"écrous",{"$f":"AVERAGEIF($C$3:$C$17,K16,$F$3:$F$17)","v":376.74599999999998},null,"Dupont",{"$f":"AVERAGEIF($B$3:$B$17,N16,$D$3:$D$17)","v":623.79999999999995}]
["2001-10-27","Dupont","pieux",145,3.72,539.4,null,{"$f":"COUNTIF(A3:A17,\">15/10/2001\")","v":6},null,null,"pieux",311.18199999999996,null,"Lambert",410.6]

{"sheet":"La fonction Si","index":1,"n_rows":43,"n_cols":5,"rows_kept":43,"cut":false,"hidden":false,"merged":[[7,0,7,1],[8,0,8,6],[9,0,9,6],[22,0,22,8],[42,0,42,8]]}
["Exemple 1"]
["Prévisions","Résultats","Objectifs 1","Objectifs 2"]
[1500,1531,{"$f":"IF(B3>A3,\"ATTEINT\",\"MANQUE\")","v":"ATTEINT"},{"$f":"IF(B3>=A3,\"ATTEINT\",\"MANQUE\")","v":"ATTEINT"}]
[2000,2984,{"$f":"IF(B4>A4,\"ATTEINT\",\"MANQUE\")","v":"ATTEINT"},{"$f":"IF(B4>=A4,\"ATTEINT\",\"MANQUE\")","v":"ATTEINT"}]
[2500,2499,"MANQUE","MANQUE"]
[3000,3000,"MANQUE","ATTEINT"]
[]
["Afficher ATTEINT ou MANQUE"]
["Objectif 1 - Si les résultats dépassent les prévisions l'objectif sera atteint sinon il sera manqué"]
["Objectif 2 - Si les résultats sont au moins équivalents aux prévisions l'objectif sera atteint sinon il sera manqué"]
[]
["Exemple 2"]
["NOMS","NOMBRE D'ENFANTS","PRIME"]
["JENNIFER",5,{"$f":"IF(B14<3,\"50\",\"70\")*B14","v":350}]
["JONATHAN",1,{"$f":"IF(B15<3,\"50\",\"70\")*B15","v":50}]
["BONNIE",2,100]
["CLYDE",1,50]
["LOIS",5,350]
["CLARK",3,210]
["BERNADETT",2,100]
["JACQUES",2,100]
[]
["Calculer une prime de 50€ par enfant si le nombre d'enfants est inférieur à 3 et une prime de 70€ par enfant pour les autres"]
[]
["Exemple 3"]
["Article","Quantité Achetée","Quantité Vendue","Quantité Restante","A commander"]
["Mars",40,22,{"$f":"B27-C27","v":18},{"$f":"IF(D27<=B27/2,\"OUI\",0)","v":"OUI"}]
["Léo",50,21,{"$f":"B28-C28","v":29},{"$f":"IF(D28<=B28/2,\"OUI\",0)","v":0}]
["Twix",25,12,13,{"$f":"IF(D29<=B29/2,\"OUI\",0)","v":0}]
["Cha-cha",35,28,7,"OUI"]
["Kinder",70,38,32,"OUI"]
["Snickers",100,47,53,0]
["Bounty",55,25,30,0]
["Lion",20,2,18,0]
["Krups",80,38,42,0]
["Smarties",60,33,27,"OUI"]
["Coca",100,62,38,"OUI"]
["Fanta",100,49,51,0]
["Sprite",100,42,58,0]
["Ice tea",100,50,50,"OUI"]
["Cécémel",100,33,67,0]
[]
["Si la Quantité Restante est inférieure ou égale à la moitié de la Quantité Achetée, il faut indiquer OUI sinon la cellule reste vide"]

{"sheet":"Si Imbriqués 1","index":2,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":false,"merged":[[18,1,18,8],[19,1,19,8]]}
[]
[null,"Nom","Prénom","Excel/20","Word/20","Powerpoint/20","Pourcentage","Conclusion 1","CC2"]
[null,"Laure","AMBART",8,17,19,{"$f":"SUM(D3:F3)/60","v":0.73333333333333328},{"$f":"IF(G3<50%,\"Echec\",IF(G3>75%,\"Réussite\",\"Bon travail\"))","v":"Bon travail"},{"$f":"IF(G3<50%,\"Echec\",IF(G3<=75%,\"Bon travail\",\"Réussite\"))","v":"Bon travail"}]
[null,"Larry","BAMBELLE",0,16,4,{"$f":"SUM(D4:F4)/60","v":0.33333333333333331},{"$f":"IF(G4<50%,\"Echec\",IF(G4>75%,\"Réussite\",\"Bon travail\"))","v":"Echec"},{"$f":"IF(G4<50%,\"Echec\",IF(G4<=75%,\"Bon travail\",\"Réussite\"))","v":"Echec"}]
[null,"Agathe","DEBLOUSE",9,9,11,0.48333333333333334,"Echec","Echec"]
[null,"Sarah","FRÉCHIS",8,12,14,0.56666666666666665,"Bon travail","Bon travail"]
[null,"Sam","GRATH",12,8,10,0.5,"Bon travail","Bon travail"]
[null,"Jacques","HOUZI",19,7,12,0.6333333333333333,"Bon travail","Bon travail"]
[null,"Guy","LIGUILI",6,12,5,0.38333333333333336,"Echec","Echec"]
[null,"Justine","MISOPOUIN",0,14,15,0.48333333333333334,"Echec","Echec"]
[null,"Alain","PROVIST",11,11,11,0.55000000000000004,"Bon travail","Bon travail"]
[null,"Jean","TAMBIEN",14,13,13,0.66666666666666663,"Bon travail","Bon travail"]
[null,"Maguy","TARE",17,15,6,0.6333333333333333,"Bon travail","Bon travail"]
[null,"Lara","TATOUILLE",18,18,13,0.81666666666666665,"Réussite","Réussite"]
[null,"Klaus","TOUMI",11,16,15,0.7,"Bon travail","Bon travail"]
[null,"Sarah","VIGOTE",15,11,12,0.6333333333333333,"Bon travail","Bon travail"]
[null,"Sacha","VIRE",19,18,14,0.85,"Réussite","Réussite"]
[]
[null,"Calculer le pourcentage de chaque élève et afficher la conclusion correspondant à ses résultats"]
[null,"CCL 1 :Si l'élève à moins de 50 % Echec, s'il a entre 50 et 75 % Bon Travail, s'il a plus de 75% Réussite"]

{"sheet":"Si Imbriqués 2","index":3,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[10,7,10,11],[11,7,11,11],[12,7,12,11],[13,7,13,11],[10,0,10,3],[11,0,11,3],[12,0,12,3],[13,0,13,3]]}
["Nom","Montant \nhors taxe","Taux de remise","Montant valeur","Montant final",null,null,"Nom","Montant \nhors taxe","Taux de remise"]
["CHRISJAN",10759,{"$f":"IF(B2>=25000,\"15%\",IF(B2>=15000,\"12,5%\",IF(B2>10000,\"7,5%\",0)))","v":"7,5%"},{"$f":"B2*C2","v":806.92499999999995},{"$f":"B2-D2","v":9952.0750000000007},null,null,"CHRISJAN",10759,{"$f":"IF(I2<10000,0,IF(I2<15000,\"7,5%\",IF(I2<25000,\"12,5%\",15%)))","v":"7,5%"}]
["VISIRIE",23299,{"$f":"IF(B3>=25000,\"15%\",IF(B3>=15000,\"12,5%\",IF(B3>10000,\"7,5%\",0)))","v":"12,5%"},{"$f":"B3*C3","v":2912.375},{"$f":"B3-D3","v":20386.625},null,null,"VISIRIE",23299,{"$f":"IF(I3<10000,0,IF(I3<15000,\"7,5%\",IF(I3<25000,\"12,5%\",15%)))","v":"12,5%"}]
["GUENOLA",9664,0,0,9664,null,null,"GUENOLA",9664,0]
["CASIQUE",9879,0,0,9879,null,null,"CASIQUE",9879,0]
["GENODI",26000,"15%",3900,22100,null,null,"GENODI",18034,"12,5%"]
["AGMIR",14058,"7,5%",1054.3499999999999,13003.65,null,null,"AGMIR",14058,"7,5%"]
["FERZIT",8985,0,0,8985,null,null,"FERZIT",8985,0]
["VALEZI",12294,"7,5%",922.05,11371.95,null,null,"VALEZI",12294,"7,5%"]
[]
["Pas de remise en-dessous de 10000 €",{"$nulls":6},"Pas de remise en-dessous de 10000 €"]
["Le taux de remise est de 7,5% à partir de 10000 €",{"$nulls":6},"Le taux de remise est de 7,5% en dessous de 15000 €"]
["Le taux de remise est de 12,5% à partir de 15000 €",{"$nulls":6},"Le taux de remise est de 12,5% en dessous de 25000 €"]
["Le taux de remise est de 15% à partir de 25000 €",{"$nulls":6},"Le taux de remise est de 15% à partir de 25000 €"]