Date: prev next · Thread: first prev next last
2021 Archives by date, by thread · List index



I guess the slave column could be column G.

Can't you just copy the $15,25 'buy price' up
into cells C:2 to C:9?  Then you can just
calc the slave in column G with a consistent
formula.



Mike


On 10/13/21 1:04 AM, users+help@global.libreoffice.org wrote:
Hello,

I have to calculate prices (buy/sell) and have a question to make it
easier. A little bit maybe:)

The file >http://status.sisi-systems.ovh/article_sample.csv

The file contains the columns Article number, text of the supplier,
purchase price, sales price, the lengths and master (1) slave (0).
The factor is for calculating the purchase price. The master (1)
can be ordered, the slave (0) items not. These are blanks.

The question is can I calculate the slaves automatically by
calculation on the basis of the master?

With  hand for example:

=C10/E10*E2
=C10/E10*E3
...

With multiple suppliers:
=(C35+C36/2)/E36*E20
=(C35+C36/2)/E36*E21
=(C35+C36/2)/E36*E22

For several articles, this is a monthly job. Isn't there a way to do this
a little automated? Comparison with article number + master / slave? When
it will only work with one supplier it will be okay.

Maybe someone have an idea? It would be great.

Thank you
Silvio


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.