# Profit & Revenue Sharing

1. ## Profit & Revenue Sharing

I have 13 members working in a project
The Net income/profit will be distributed as "Bonus" on the basis of their performance rating.

Points Rating
1 5%
2 7%
3 9%
4 10%
5 12%

The Net profit amount is fixed, I want a formulae to derive, distribution of amount basis on the percentage for each member
Attached the excel

2. ## Re: Profit & Revenue Sharing

d1=\$C3*\$E\$1 and drag down.

But sum(c3:c16) = 107%

3. ## Re: Profit & Revenue Sharing

this did not work.

4. ## Re: Profit & Revenue Sharing

Your column C formula is incorrect. Put up a separate VLOOKUP Table and reference the formula in column C to this table.

Distribution amount for each member is the Percentage of Sharing divided by the total of Percentage of Sharing.

5. ## Re: Profit & Revenue Sharing

Explain in detail "did not work".

You have several threads here where you have never thanked anyone for the help they have given you - you might wish to address this oversight during this visit to the forum.

6. ## Re: Profit & Revenue Sharing

Solved.. Thank you!!

7. ## Re: Profit & Revenue Sharing

E3 =\$B3/SUM(\$B\$3:\$B\$16)*\$E\$1 and drag down.

8. ## Re: Profit & Revenue Sharing

If you are satisfied with the solution, please mark the question solved.

You can add reputation by clicking on the star * add reputation.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1