I need help or a starting point – calculating in Libre Office?
Can anyone possibly help me?
I have to do some calculations using Libre Office.
On the subject…
Think of products including price and then calculate as given in the table.
Purchase price, selling price, etc. see picture.
Unfortunately, I'm missing the beginning.
Does anyone have any advice?
Since the VK is dependent on the Mwst set, you should take it as a basis with the EK in the formulas. Then you just have to enter the formulas per line… So enter Mwst and refer to the formulas. How you shape these things doesn’t matter. Mwst amount is “EK*Mwst set/100”, VK is “EK+Mwst amount” or “EK*Mwst set/100+EK” (alternatively “EK*(100+Mwst set)/100” if you don’t want to pay for yourself…