I am trying to determine how to go about generating a formmula for Excel
which will assit in working out a percentage increase.

The scenario is as follows:

An amount of $100 000 is to be distributed between 6 individuals at the rate
of 15% each. Another individual is to receive 10% of the $100 000. One of the
6 individuals has withdrawn from the scheme and their 15% share is now to be
distributed between the remainder of the individuals in proportion to the
share that they would receive. For example each individual who is entitled to
15% would get a proportionately greater share then the one who is entitled to
10%.


In essence I have a situtation where 85% of the available funds can be
distributed as planned and I now need to determine the additional percentage
that each individual will receive (based on whether they were to get 10% or
15%) due to the withdrawal of one party. What I need is a formula in which I
can substitute the money values and percentage values as required on a case
by case basis.

Any help would be greatly appreciated.

--
Confused Law Student