Hi All,
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.
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.