I am trying to distribute the same ration percent even after I change the GM%. Here is what I have:

Salary Cost 60%

Holiday cost 5%

Payroll taxes 10%

All the above = 75% which mean my GM% is 25%

What I am trying to do is change the cell that contains the GM% to let's say 30% but I would like the cells that contain the ratio % to distribute evenly per the historical ratios to equal 70%

So if I change my GM% cell to 30% Cells B1,B2,B3 should automatically calculate 60% of the 70%, then 5% of the 70% and then 10% o the 70%. What should be my formula?

Sorry if I did not explain this right I am having trouble articulating it.