H
Herman56
I have to feed back data from my products list to my pricelis
worksheet. That would not have been a problem normally, but in thi
case I am passing the magical 7-IFs boarder... I need to do th
following:
In the products-sheet I have got multiple 'packings-units'. Each uni
is build up simular, starting with the 125 ml packing:
BC3 = "x" (tag)
BD3 = netto price/liter
BE3 = taxes (formula)
BF3 = bruto price/liter (formula)
BG3 = netto price/packing i.e. 125 ml (formula)
BH3 = bruto price/packing i.e. 125 ml (formula)
BI3 = packings/box (formula)
BG3 = netto price/box (formula)
BH3 = bruto price/box (formula)
In the pricelist table I got after the product names and the packinge
(125 ml is tagged at C3) the following:
M3 = netto/packing (i.e. 125 ml)
N3 = bruto/packing (i.e. 125 ml)
O3 = packings/box
P3 = netto price/box (formula)
Q3 = bruto price/box (formula)
The setup is the following: each packing type is tagged per product o
the pricelist. For each packing/product there will be one line. The ta
is transferred by formula to the products list, in this case BC3. The
the netto price per liter per packing type will be added in th
products list (in this case BD3), and all different needed prices ar
calculated in the products list. So far no problems (anymore)...
But now I need to get the proper prices from the products lis
transferred to the pricelist... Since I got 9 different packing-type
at this moment, and maybe even more to come, I cannot work with th
IF-formula to get my data. I have been thinking about the SUMPRODUC
formula, but could not figure out how to use this formula this time..
Is there anyone around that can direct me to the proper formulas t
use? Or should I create a helper table first? (Been thinking about tha
one too, but I still got caught in the 7-IFs rule...)
What should I do/what should I use? Any help is appreciated very much!
Pau
worksheet. That would not have been a problem normally, but in thi
case I am passing the magical 7-IFs boarder... I need to do th
following:
In the products-sheet I have got multiple 'packings-units'. Each uni
is build up simular, starting with the 125 ml packing:
BC3 = "x" (tag)
BD3 = netto price/liter
BE3 = taxes (formula)
BF3 = bruto price/liter (formula)
BG3 = netto price/packing i.e. 125 ml (formula)
BH3 = bruto price/packing i.e. 125 ml (formula)
BI3 = packings/box (formula)
BG3 = netto price/box (formula)
BH3 = bruto price/box (formula)
In the pricelist table I got after the product names and the packinge
(125 ml is tagged at C3) the following:
M3 = netto/packing (i.e. 125 ml)
N3 = bruto/packing (i.e. 125 ml)
O3 = packings/box
P3 = netto price/box (formula)
Q3 = bruto price/box (formula)
The setup is the following: each packing type is tagged per product o
the pricelist. For each packing/product there will be one line. The ta
is transferred by formula to the products list, in this case BC3. The
the netto price per liter per packing type will be added in th
products list (in this case BD3), and all different needed prices ar
calculated in the products list. So far no problems (anymore)...
But now I need to get the proper prices from the products lis
transferred to the pricelist... Since I got 9 different packing-type
at this moment, and maybe even more to come, I cannot work with th
IF-formula to get my data. I have been thinking about the SUMPRODUC
formula, but could not figure out how to use this formula this time..
Is there anyone around that can direct me to the proper formulas t
use? Or should I create a helper table first? (Been thinking about tha
one too, but I still got caught in the 7-IFs rule...)
What should I do/what should I use? Any help is appreciated very much!
Pau