percentage calculation

[Lars1]

I have a problem with a percentage calculation.
Hope someone could help.

I have a blend where it is essential that the relation between the three ingrediens is correct/fixed.

How to calculate how much to add of ingrediens 2 and 3, if i add extra ingrediens 1 ?
How to calculate how much to add of ingrediens 3, if i add extra ingrediens 1 and 2 ?
How to calculate how much to add of ingrediens 1 and 3, if i add extra ingrediens 2 ?
etc.

in the example below i have 100 kg. total and i then add extra ingrediens 1.

 

[maabadi]

For add One Ingredient:
Multiply Extra At Value of Other ingredient ( or Percentage) (one by one) then Divide at the Value of Ingredient (or Percentange) that added
If add Extra at Ing. 1 then multiply extra at value of ing. 2 then divide to value of ing. 1 ( do same for ing. 3 & Total)

For add Two Ingredient:
You should first do above steps for each one without adding others at 2 separate steps
then select each one you want

Example:

Book1
	A	B	C	D	E	F	G	H	I
1		%	Kg	Add Extra (kg)		Add Extra (kg)	Calculate Ingr2 & 3 with if Add Ingr. 1	Calculate Ingr1 & 3 with if Add Ingr. 2
2	Ingredient 1	32.5%	32.50	24.00		20	20.00	21.67
3	Ingredient 2	37.5%	37.50	27.69		25	23.08	25.00
4	Ingredient 3	30.0%	30.00	22.15			18.46	20.00
5		100%	100.00	73.85			61.54	66.67
6
7				ADD Ingr. 1		ADD Ingr. 1 & 2
8
Sheet1

Cell Formulas
Range	Formula
H2,H4:H5	H2	=$H$3*C2/$C$3
G3:G5	G3	=$G$2*C3/$C$2
B2:B4	B2	=C2/$C$5
D3:D5	D3	=$D$2*C3/$C$2
B5:C5	B5	=SUM(B2:B4)

 

[Lars1]

For add One Ingredient:
Multiply Extra At Value of Other ingredient ( or Percentage) (one by one) then Divide at the Value of Ingredient (or Percentange) that added
If add Extra at Ing. 1 then multiply extra at value of ing. 2 then divide to value of ing. 1 ( do same for ing. 3 & Total)

For add Two Ingredient:
You should first do above steps for each one without adding others at 2 separate steps
then select each one you want

Example:

Book1
	A	B	C	D	E	F	G	H	I
1		%	Kg	Add Extra (kg)		Add Extra (kg)	Calculate Ingr2 & 3 with if Add Ingr. 1	Calculate Ingr1 & 3 with if Add Ingr. 2
2	Ingredient 1	32.5%	32.50	24.00		20	20.00	21.67
3	Ingredient 2	37.5%	37.50	27.69		25	23.08	25.00
4	Ingredient 3	30.0%	30.00	22.15			18.46	20.00
5		100%	100.00	73.85			61.54	66.67
6
7				ADD Ingr. 1		ADD Ingr. 1 & 2
8
Sheet1

Cell Formulas
Range	Formula
H2,H4:H5	H2	=$H$3*C2/$C$3
G3:G5	G3	=$G$2*C3/$C$2
B2:B4	B2	=C2/$C$5
D3:D5	D3	=$D$2*C3/$C$2
B5:C5	B5	=SUM(B2:B4)

[Works perfect - THAN

Cell Formulas
Range	Formula

For add One Ingredient:
Multiply Extra At Value of Other ingredient ( or Percentage) (one by one) then Divide at the Value of Ingredient (or Percentange) that added
If add Extra at Ing. 1 then multiply extra at value of ing. 2 then divide to value of ing. 1 ( do same for ing. 3 & Total)

For add Two Ingredient:
You should first do above steps for each one without adding others at 2 separate steps
then select each one you want

Example:

Book1
	A	B	C	D	E	F	G	H	I
1		%	Kg	Add Extra (kg)		Add Extra (kg)	Calculate Ingr2 & 3 with if Add Ingr. 1	Calculate Ingr1 & 3 with if Add Ingr. 2
2	Ingredient 1	32.5%	32.50	24.00		20	20.00	21.67
3	Ingredient 2	37.5%	37.50	27.69		25	23.08	25.00
4	Ingredient 3	30.0%	30.00	22.15			18.46	20.00
5		100%	100.00	73.85			61.54	66.67
6
7				ADD Ingr. 1		ADD Ingr. 1 & 2
8
Sheet1

Cell Formulas
Range	Formula
H2,H4:H5	H2	=$H$3*C2/$C$3
G3:G5	G3	=$G$2*C3/$C$2
B2:B4	B2	=C2/$C$5
D3:D5	D3	=$D$2*C3/$C$2
B5:C5	B5	=SUM(B2:B4)

Works perfect - THANKS

 

[maabadi]

You're Welcome & thanks for Feedback.