Sep 30 2021 12:57 PM
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
Oct 03 2021 01:42 AM
@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
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