SI.CONDITION

%3CLINGO-SUB%20id%3D%22lingo-sub-1284853%22%20slang%3D%22fr-FR%22%3EIf.%20Condition%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1284853%22%20slang%3D%22fr-FR%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20to%20do%20a%20computational%20file%20and%20I%20don't%20know%20what%20formula%20to%20use.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'll%20put%20you%20in%20context.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%2014-inch%20and%2015-inch%20laptop%20controls.%20These%20will%20be%20ordered%20for%20different%20sites.%20When%20laptops%20are%20delivered%2C%20they%20must%20be%20added%20to%20the%20amount%20of%20laptops%20that%20are%20already%20in%20stock%20according%20to%20the%20model%20and%20the%20site.%20Example%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EStock%20Model%20Site%3C%2FP%3E%3CP%3EHospital%2010%2014%20inches%3C%2FP%3E%3CP%3EHospital%2010%2015%20inches%26nbsp%3B%3C%2FP%3E%3CP%3EHospital%20B%205%2014%20inches%3C%2FP%3E%3CP%3EHospital%20B%205%2015%20inches%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOrder%3C%2FP%3E%3CP%3EModel%20Reception%20Site%3C%2FP%3E%3CP%3EHospital%205%2014%20inches%3C%2FP%3E%3CP%3EHospital%20B%205%2015%20inches%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20result%20should%20be%3A%3C%2FP%3E%3CP%3EStock%20Model%20Site%3C%2FP%3E%3CP%3E%3CSTRONG%3EHospital%2015%3C%2FSTRONG%3E%2014%20inches%20(new%20stock%20following%20receipt%20of%2014-inch%20laptops)%3C%2FP%3E%3CP%3EHospital%2010%2015%20inches%26nbsp%3B%3C%2FP%3E%3CP%3EHospital%20B%205%2014%20inches%3C%2FP%3E%3CP%3EHospital%20B%20%3CSTRONG%3E10%3C%2FSTRONG%3E%2015%20inches%20(new%20stock%20following%20receipt%20of%2015-inch%20laptops)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20don't%20know%20how%20to%20make%20my%20formula.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKristina%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1284853%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

Bonjour,

 

Je dois faire un fichier de calcul et je ne sais pas quelle formule utiliser.

 

Je vous mets en contexte.

 

J'ai des commandes de portables 14 pouces et 15 pouces. Ceux-ci seront commandés pour différents sites. Quand les portables sont livrés, ils doivent être additionnés à la quantité de portable qu'il y a déjà en stock selon le modèle et le site. Exemple :

 

Site                        Stock               Modèle

Hôpital                    10                   14 pouces

Hôpital                    10                  15 pouces 

Hôpital B                 5                     14 pouces

Hôpital B                 5                     15 pouces

 

Commande

Site                    Réception                Modèle

Hôpital                    5                         14 pouces

Hôpital B                 5                         15 pouces         

 

Résultat doit être :

Site                        Stock               Modèle

Hôpital                    15                   14 pouces (nouveau stock suite à la réception des portables 14       pouces)

Hôpital                    10                  15 pouces 

Hôpital B                 5                     14 pouces

Hôpital B                 10                     15 pouces (nouveau stock suite à la réception des portables 15 pouces)

 

Je ne sais pas comment faire ma formule.

 

Merci!

 

Kristina

0 Replies