Re: [libreoffice-users] Buy/Sell Calculation

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