Formula to show quantities for amount entered

hi, i'm new in here.

ref attachment.

I have quantities of some items to manufacture a 1000 kgs product (new product).

How should i set formula to show me the quantities required for all items based on an amount i enter at I23 ?

Can you post a sheet not a photo

Hi mutedf8 ,
No really understand your question.
Do you mean if your enter 1000KG at cell I23, you need auto assign each Type1 to Type18 's quantity and sum up will equal to 1000KG?

Originally Posted by wenqq3

Hi mutedf8 ,
No really understand your question.
Do you mean if your enter 1000KG at cell I23, you need auto assign each Type1 to Type18 's quantity and sum up will equal to 1000KG?

yes bro !

also if i put any quantity on that cell (I 23), the rest all cells (type 1 to type 18) should auto assign based on the quantity which i entered.

tks.

Still confusing.

Do you mean if your enter 1000KG at cell I23, you need auto assign each Type1 to Type18 's quantity and sum up will equal to 1000KG?

Based on my comment, so i can assing 1000/18 = 55.555555 for each type1 to type18?

Or can you do more example, so i can see the different that "Auto assign". thanks

Hi and welcome to the forum

If I understand you correctly, 1st, create a helper column (I used J) and then follow these steps...

1. In J5, copied down use =I5/$I$23
2. Copy that entire range, and then paste/values over itself, so that you are just left with the values as shown below
3. Enter a value in I23 (1000 is a go number to test with)
4. in I5, copied down to I22, use =$I$23*J5
Now when you enter any value in I23, the cells above will change accordingly. You can hide the helper if you want

	G	H	I	J
4	Code	Description	Req'd Qty
5	1	type 1	5.3400	0.00534
6	2	type 2	11.2600	0.01126
7	3	type 3	4.1000	0.0041
8	4	type 4	6.5000	0.0065
9	5	type 5	12.9600	0.01296
10	6	type 6	4.0200	0.00402
11	7	type 7	5.5800	0.00558
12	8	type 8	30.8300	0.03083
13	9	type 9	9.2980	0.009298
14	10	type 10	25.5200	0.02552
15	11	type 11	2.7900	0.00279
16	12	type 12	0.4000	0.0004
17	13	type 13	2.5200	0.00252
18	14	type 14	2.8300	0.00283
19	15	type 15	1.6600	0.00166
20	16	type 16	2.3000	0.0023
21	17	type 17	0.1300	0.00013
22	18	type 18	871.962	0.871962
23		NEW PRODUCT	1000.0000

Based on your file,
i think FDibbins already give you the answer