If you want to get a little fancier, say, for example, some people didn't
want a 'full share' only 50% share, etc. You could do the following:
A1: Purchase Price
B1*: Shares
C1: =IF(OR(A1="",B1=""),"",A1/B1)

Shares is equal to the number of partners you have, however, say you have 6
people that want to be full partnes, and 2 people that wanted to be less than
a full partner, say one is 75%, and one is 50%. Then the subsequent shares
would be equal to 6*1+.75*1+.5*1 = 7.25
A Share price is equal to: $386,450/7.25 = $53,303.45
All full partners would pay the $53,303.45
The 75% partner would pay 75% of 53,303.45 = $39,977.59
The 50% partner would pay 50% of 53,303.45 = $26,651.72

--
John C


"Mike H" wrote:

There are several ways and this is probably the simplest

Put the purchase price in a1
Put this formula in b1
=IF(C1="","",A1/C1)

enter different numbers in c1 to get the amount depending on partners.

Mike

"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.
--
Thank you for your help.
Bill