recalculate % based on new conditions

[nurgazik]

I have 5 numbers (% of a sum): 20.89%, 26.53%, 21.68%, 19.93%, 10.96% - totaling to 99.99%

Now I am removing the amounts with corresponding percentages of 26.53% and 10.96%

My new "100%" is now represented with three amounts that had an initial percentage: 20.89%, 21.68%, 19.93%

Question: How do I recalculate these three % (20.89, 21.68, 19.93) so that they total up t 100%?

Note: I cannot use the actual amounts and have to work with % numbers only.

 

[tkhunny]

Have you considered dividing each by the sum of the three?

 

[nurgazik]

Have you considered dividing each by the sum of the three?

I think I've figured what you mean -it work. Thanks a lot!

x = 20.8
y = 21.68
z = 19.93

t = x +y + z (62.41)

x = x * 100/ 62.41 (33.33)
y = y * 100/62.41 (34.73)
z = z * 100/62.41 (31.93)

 

[nurgazik]

Same result, but easier/cleaner: z = 100 - x - y

I don't think so. note that I do not know my new values z, x, y until I compute their *100/ total.

otherwise, if I use the old values then: z = 100 - 21.68 - 19.93 = 58.39

Or maybe I misunderstood you?