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