I'm trying to create a formula that will distribute X% proportionally to other %s in a table.

For example: I have 5 rows of %s that always add up to 100%.

1= 40%

2= 20%

3= 16%

4= 14%

5= 10%

If I remove 5 (10%) and want to distribute that 10% proportionally to 1-4, and still maintain 100% total; what does my formula look like? Initially I thought I could do:

1= (40%*10%) = 44%

2= (40%*10%) = 22%

3= (40%*10%) = 17.6%

4= (40%*10%) = 15.4%

Problem is this only adds up to 99%. What am I missing?

Thanks!

Kevin