Prev: How to Convert 24/03/2010 as text into 03/24/2010 date format
Next: sum by rows in Pivot
From: SF123 on 5 Jun 2010 00:43
Am trying to construct formula in excel 2007 for maintaining a constant percentage. Example: company 1 has 1,000 shares. Company 2 wants to purchase 10% of company 1 and always maintain the 10% rate. Buying 10% more shares would give a total of 1,100 and their percentage would be less than 10%. What formula can be used to calculate this and would find out how many more shares they would need to purchase in the event company 3 purchases X shares.

---
frmsrcurl: http://msgroups.net/microsoft.public.excel.worksheet.functions
From: Steve on 6 Jun 2010 11:41
Try thinking backwards, If company 1 has 90% of the shares and company 2 has
10%. Then all you do is divide 1000 by 90 and then multiply by 10 =111.11 Or
just to make life easier divide 1000 by 9. If company 3 buys shares then all
you do is add the shares of company 1 and company 3 and divide by 9 that
gives company 2 10% of the total.

Regards
Steve

"SF123" wrote:

> Am trying to construct formula in excel 2007 for maintaining a constant percentage. Example: company 1 has 1,000 shares. Company 2 wants to purchase 10% of company 1 and always maintain the 10% rate. Buying 10% more shares would give a total of 1,100 and their percentage would be less than 10%. What formula can be used to calculate this and would find out how many more shares they would need to purchase in the event company 3 purchases X shares.
>
> ---
> frmsrcurl: http://msgroups.net/microsoft.public.excel.worksheet.functions
> .
>
 | 
Pages: 1
Prev: How to Convert 24/03/2010 as text into 03/24/2010 date format
Next: sum by rows in Pivot