Pranavesh Shenoy
New Member
Members
Forum Posts: 1
Member Since:
July 4, 2020
July 4, 2020
Offline
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: 414
Member Since:
December 20, 2019
December 20, 2019
Offline
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: Warren Murphy, Kathleen Silva, Brenda Wolf
Guest(s) 10
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1917
SunnyKow: 1432
Anders Sehlstedt: 900
Purfleet: 414
Frans Visser: 346
David_Ng: 306
Hans Hallebeek: 290
lea cohen: 246
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Cassandra McGuire
Leo Bonaparte
Excel Learner
david gavi
Rick KISA
Jan Elenbaas
Ranjeet Wankhade
Sugata Maity
Karen McCarron
Amanda Zibell
Forum Stats:
Groups: 3
Forums: 24
Topics: 6880
Posts: 30158
Member Stats:
Guest Posters: 49
Members: 33702
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —