##### Honorable
I want to calculate each group percentage cut base on how much money they put in and I want Group 1 to have a +5% more over the others.

So I have this Spreadsheet screenshot, but Im still having problem how I will calculate the +5% more of Group 1.

#### kanewolf

##### Titan
Moderator
I want to calculate each group percentage cut base on how much money they put in and I want Group 1 to have a +5% more over the others.

So I have this Spreadsheet screenshot, but Im still having problem how I will calculate the +5% more of Group 1.
When you say 5% more than the others. Do you mean 5% more than all the others or 5% more than an individual ?
If it is all the others then the group1 has to have 52.5% of the total. That leaves 47.5% for the other three groups so that there is a 5% of the total difference.

##### Honorable
When you say 5% more than the others. Do you mean 5% more than all the others or 5% more than an individual ?
If it is all the others then the group1 has to have 52.5% of the total. That leaves 47.5% for the other three groups so that there is a 5% of the total difference.
I mean 5% more than all the others and 52.5% and 47.5% If they have all equal share.
But how about if they have unequal shares and group 1 still 5% more than all of the other groups how do you calculate that?

#### USAFRet

##### Titan
Moderator
Give Group 1 52.5% of the total.
Split the rest proportionally.

#### kanewolf

##### Titan
Moderator
I mean 5% more than all the others and 52.5% and 47.5% If they have all equal share.
But how about if they have unequal shares and group 1 still 5% more than all of the other groups how do you calculate that?
Sum of groups 2 - N == 47.5% of X, so X = sum / 47.5% Then multiply X by 52.5% to get group 1

• ##### Honorable
Give Group 1 52.5% of the total.
Split the rest proportionally.
I also want to make it look like this so it will be easier to see each group percentage.

#### kanewolf

##### Titan
Moderator
I also want to make it look like this so it will be easier to see each group percentage.
Read my post. It gives you the formulas..

• USAFRet

##### Honorable
Read my post. It gives you the formulas..
Im maybe dumb but how do you apply that formula to work in google spreadsheet.

#### kanewolf

##### Titan
Moderator
Im maybe dumb but how do you apply that formula to work in google spreadsheet.
Assuming A2 - A5 are the "rest" of the values with values of 100, 200, 150, 75
A1 = (sum(a2:a5)/47.5%)*52.5%
A1 = 580.2632 == 52.5% of the total of a1 - a5.

 Value Percent 580.26​ 52.5%​ 100.00​ 9.0%​ 200.00​ 18.1%​ 150.00​ 13.6%​ 75.00​ 6.8%​ 100.0%​

Replies
9
Views
2K
Replies
4
Views
1K
Replies
5
Views
964
Replies
5
Views
2K
Replies
5
Views
962