Hi, any help would be great.
I need to work out a way of splitting different percentages of a profit between people.
Ten people split the profit (£1000) between them. But not equally.
4 people (A-D) need to get 30% more than the other 6 people (E-J).
I have worked this out manually as:
A 11.6% £116.00
B 11.6% £116.00
C 11.6% £116.00
D 11.6% £116.00
E 8.93% £89.30
F 8.93% £89.30
G 8.93% £89.30
H 8.93% £89.30
I 8.93% £89.30
J 8.93% £89.30
Is there an equation to work this out?
I need to work out many more percentage splits and by different amounts of people.
Ten people split the profit between them. But not equally.
3 people (A-C) need to get 40% more than the other 7 people (D-J).
...I could work it out manually... But I need it as an equation so i can change the number of people who receive more and the percentage relative to the others that they receive. I will also need to work this out for 8 people and 6 people etc... and get it into a Exel spreadsheet!
Please help - I can't get my head round it!!!