tableau excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2800748%22%20slang%3D%22fr-FR%22%3Eexcel%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2800748%22%20slang%3D%22fr-FR%22%3E%3CP%3EHello%20everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20going%20to%20list%20items%20on%20an%20online%20store%20and%20I'd%20like%20to%20manage%20the%20stock%20via%20Excel.%3C%2FP%3E%3CP%3EHere%20are%20the%20different%20lines%20in%20screenshot%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3EThank%20you%20very%20much%20for%20your%20help%2C%20dan%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2800748%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2806635%22%20slang%3D%22en-US%22%3ERe%3A%20tableau%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2806635%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1171694%22%20target%3D%22_blank%22%3E%40dan025%3C%2FA%3E%26nbsp%3BHi%20Dan%3C%2FP%3E%3CP%3EDo%20you%20want%20help%20to%20calculate%20the%20benefits%2Fwinnings%3F%3C%2FP%3E%3CP%3EThe%20translation%20from%20french%20is%20kind%20of%20a%20guessing%20game%20but%20with%20that%20said%2C%20it%20seems%20you%20are%20quite%20near.%20One%20cell%20equals%20a%20calculation%20of%20others%2C%20ie%20in%20cell%20C2%20you%20can%20write%3C%2FP%3E%3CP%3E%3DA2-B2%3C%2FP%3E%3CP%3Eand%20get%20the%20remaining%20items.%20In%20cell%20G2%3C%2FP%3E%3CP%3E%3D(D2-E2)-F2%3C%2FP%3E%3CP%3Eor%20maybe%3C%2FP%3E%3CP%3E%3DB2*(D2-E2)-F2%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22bosinander_0-1633248781972.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F314641i384C2ADD54F2F182%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22bosinander_0-1633248781972.png%22%20alt%3D%22bosinander_0-1633248781972.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EFinally%2C%20copy%20the%20cell%20with%20the%20formula%2C%20select%20the%20empty%20cells%20with%20new%20lines%20and%20paste.%3C%2FP%3E%3CP%3EThere%20are%20a%20lot%20of%20maore%20ways%20to%20do%20this%2C%20but%20this%20may%20be%20a%20start.%3C%2FP%3E%3CP%3EIn%20the%20attached%20file%2C%20you%20also%20have%20a%20more%20modern%20way%20to%20do%20it%2C%20using%20a%20(pyamas)%20Table%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Bonjour à toutes et à tous,

 

Je vas mettre des objets en vente sur une boutique en ligne et je voudrais gérer le stock via Excel.

Voici les différents lignes en capture d'écran

 

Merci beaucoup pour votre aide, dan

1 Reply

@dan025 Hi Dan

Do you want help to calculate the benefits/winnings?

The translation from french is kind of a guessing game but with that said, it seems you are quite near. One cell equals a calculation of others, ie in cell C2 you can write

=A2-B2

and get the remaining items. In cell G2

=(D2-E2)-F2

or maybe

=B2*(D2-E2)-F2

bosinander_0-1633248781972.png

Finally, copy the cell with the formula, select the empty cells with new lines and paste.

There are a lot of maore ways to do this, but this may be a start.

In the attached file, you also have a more modern way to do it, using a (pyamas) Table