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/