Multiple IF To Solve Equalization

to allocate funds to various organisations with a number of constraints (see spreadsheet attached I work in Excel 2007 but saved the file in 2003):

1. No negative growth can be allowed (Column M which is difference between columns Q and B) and I therefore added Column N to bring the growth in Column R to 0% for those which had a growth of less than 6%.

2. Minimum growth however allowed should be 6%

3. Maximum growth allowed should be 50% (not all need to have 50% growth)

4. The balance of the allocations to organisations with growth more than 50% should be used to "equalize" allocations proportionately between the other organisations with growth lower than 50%