Formula to allocate fractions as a numbers

[Salut39]

Hi Guys,
I have a problem with the formula. The situation is: I have some companies formed which with take a different roots. 25% say will be sold, 75% will be liquidated. I can't use percentage as I need round numbers. Percentages have to be variables too. See what I have done:
Companies Formed 1 1 1 1
Companies Sold - - - 1
Companies Liquidated 1 1 1 -
25.0% IF(SUM($B1:C$1)=0,0,IF(((SUM(B2:$B$2)+C1)/SUM($B1:C$1))<=$A$4,C1,0))

This formula i used to work it out. But it works only for 1 company, when it's more than 1 it make the same root.
Companies Formed 2 2 2 2
Companies Sold - - - 2
Companies Liquidated 2 2 2 -

The correct result should be like this.
Companies Formed 2 2 2 2
Companies Sold - 1 - 1 25.0%
Companies Liquidated 2 1 2 1 75.0%
I would appreciate help. I hope I have explained enough.

Thx Yuri

 

[PHV]

Here is the VBA forum.
For formula issues best to ask here: forum68

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886