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
d1=$C3*$E$1 and drag down.
But sum(c3:c16) = 107%
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
this did not work.
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.
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.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Solved.. Thank you!!
E3 =$B3/SUM($B$3:$B$16)*$E$1 and drag down.
Glad I could help.
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
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks