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
Bookmarks