{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Feuil1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":37,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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":"Feuil1","index":0,"n_rows":36,"n_cols":6,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["EXEMPLES D'UTILISATION DE LA FONCTION LAMBDA :"]
[]
["Calcul d'un montant TTC à partir d'un montant HT et d'un taux de TVA :"]
[]
[null,"Montant HT :",1000]
[null,"Taux de TVA :",0.2]
[]
[null,"Montant TTC :"]
[null,"Fonction LAMBDA :",null,{"$f":"Calcule_MtTTC($C$5,$C$6)","v":1200}]
[null,"Fonction VBA :",null,{"$f":"Calcule_MtTTC_vba($C$5,$C$6)","v":1200}]
[]
[]
["Calcul d'un montant facturé net de remise (bis)"]
[]
[null,"Grille des taux de remise :"]
[null,"Mt f/re HT >= à","Tx remise ="]
[null,100,0.1]
[null,150,0.15]
[null,500,0.2]
[null,1500,0.25]
[]
[null,"Détail de la facture :"]
[null,null,null,null,"Contrôle"]
[null,"Article","Quantité","Prix unitaire","HT"]
[null,"Article 1",5,10,{"$f":"C25*D25","v":50}]
[null,"Article 2",3,8.5,{"$f":"C26*D26","v":25.5}]
[null,"Article 3",2,15,30]
[null,null,null,null,{"$f":"SUM(E25:E27)","v":105.5},"Total HT avant remise"]
[null,"Tx remise :",{"$f":"_xlfn.XLOOKUP(E28,B17:B20,C17:C20,0,-1,-1)","v":0.1},null,{"$f":"E28*C29","v":10.55},"Mt remise"]
[]
[null,"Mt total net de remise :",null,{"$f":"CalculFactureHTNetteRemise(C25:C27,D25:D27,B17:B20,C17:C20)","v":94.95},{"$f":"E28-E29","v":94.95}]
[]
[null,"Montant TTC :",null,{"$f":"Calcule_MtTTC(D31,20%)","v":113.94}]
[]
[]
["Plus d'infos :","https://www.auditsi.eu/?p=11526"]