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, [email protected] 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: [email protected] 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
