
Pranavesh Shenoy
New Member
Members

Forum Posts: 1
Member Since:
July 4, 2020
July 4, 2020

I have 13 members working for a project, Now we have got Net Income.
We also have each member performance rating points, viz-a-viz Percentage of share of profits.
Now, the amount is fixed, I want to generate a formula,where I distribute the amount % wise, not exceeding the net Income.
NetIncome | 100000 | ||
Points | Percentage | Distribution | |
4 | 10% | *Formula To be added* | |
4 | 10% | ||
3 | 9% | ||
4 | 10% | ||
2 | 7% | ||
3 | 9% | ||
2 | 7% | ||
1 | 5% | ||
2 | 7% | ||
3 | 9% | ||
2 | 7% | ||
2 | 7% | ||
1 | 5% | ||
1 | 5% |
Please help

Purfleet
England
Member
Members

Trusted Members

Trusted Members

Forum Posts: 412
Member Since:
December 20, 2019
December 20, 2019

Not sure if it is a typo but the percentage in the list is more than 100.So i re-calc'd the percentage based on the points - see attached
Btw is also better to add an example worksheet rather than paste data in, that way we dont waste time recreating the data and there is less chance of getting it wrong.
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Jan pedersen, Francis Drouillard
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 870
Purfleet: 412
Frans Visser: 346
David_Ng: 306
lea cohen: 219
A.Maurizio: 202
Jessica Stewart: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
wahab tunde
Cong Le Duc
Faisal Bashir
Ivica Cvetkovski
Blaine Cox
Shankar Srinivasan
riyepa fdgf
Hannah Cave
Len Matthews
Kristine Arthy
Forum Stats:
Groups: 3
Forums: 24
Topics: 6205
Posts: 27209
Member Stats:
Guest Posters: 49
Members: 31878
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —
