Formula for calculating weightings

[stevefleming1967]

I currently have a sum of £230,000 which is made up of shares invested by 5 companies at £70,000, £50,000, £45,000, £35,000 and £30,000.  The percentage value of these shares is easy to calculate.  However, if I want to divide the £230,000 between 4 companies based on the current percentages I will get a gap of c 15%.  Is there a formula to split the £230,000 between 4 based on the weightings each has without losing the 15%. Many Thanks

[#2 · Accepted solution]

@stevefleming1967 

Well, rather than dividing each of the 5 shares by the total of 230K, divide each of the four shares you selected by the sum of these four. four instance:

[#3]

Thank you so much, that's very helpful.