I would like to be able to change a value of a percentage of a total

I would like to be able to change the value of a percentage of a total and have all the other percentages as well as the total up dated.

For example: I have a formula that is say a total of 2000ml made up of 6 ingredient with various percentages. A 600 = 30% B 400 = 20% C 200 = 10% D 100 = 5% E 300 = 15% F 500 = 25%
So if I change the value of say F to 550, I would like all the other values including the total to update correctly so that the ratio always stays correct.

I am totally new at Excel and am not a numbers person. So please someone help me??

Thank you so much.

Ratio.PNG

Sorry, but this is what I mean. So if I wanted to change F to 450 and update the percentage ratio and the total to be 2050 ml

It is important that the actual percentages always remain the same. I hope I am explaining myself properly here

I don't think I explained myself properly.
Each ingredient is related to a specific percentage of the total. I would like to be able to change the quantity of any one of the ingredients and have the other ingredients
update as well as the total.

Formula a.xlsx

At the moment I change the total until I get the amount I'm looking for. There has to be an easier way to do this.

Thank you all for your help.

Yes, that is what I want to do, but on any of the ingredients. So if for example I have only enough stock of ingredient a, I can type it in to see how much stock I would need of the other ingredients.

Do you think that is possible to do?

Yes, that is what I want to do, but on any of the ingredients. So if for example I have only enough stock of ingredient a, I can type it in to see how much stock I would need of the other ingredients.

Do you think that is possible to do?

Thank you so much! This will make my life so much easier