Dears, I would much appreciate provovidin me support in finding a formula for dividing a value based on some criteria. For instance I have to equally share value 66 to 12 persons based on some criteria. Person 1 has a quota of 120 units and he was fulfilled it to a procentahe of 75%, person 2 has a quota of 45 units and has fulfilled it in a procentahe of 35% and so on. How do I share the value of 66 based on the fulfilled quota equally based on theirs units and quota coverage procentahe. Thanks in advance for any possible support. All the best!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Finding a formula for equality dividing a value based on quota and procentages
- Thread starter DaVinci07
- Start date
No problem. I appreciate your interest. I still hope that there’s a formula as a solution to my problem. All the best!
Upvote
0
Similar threads
- Question
