Bill Booth wrote:
I am buying a new business with partners. The cost is $386,450. We may have
up to 10 partners, so each would contribute $38,645. I would like to build a
table that allows "what if" scenario. For example if we only get 8 partners
how much do the 8 need to contribute, or 6, 9, 7 and so on. How can I develop
a formula that will allow me add to remove partner contribution levels and
still keeping the total amount $386,450? I would like to do this real time
during a presentation with the partners present.

The cost per share of the new business is $386,450/n with n being the number of
shares. Put $386,450 in cell A1 and the following in B1 and C1, copying down as
far as necessary:

B1=ROW()
C1=$A$1/ROW()