Excel Forum

Profit Revenue Sharing Formula

Pranavesh Shenoy

New Member

Members

Forum Posts: 1

Member Since:
July 4, 2020

Offline

July 4, 2020 - 10:26 pm

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

Forum Posts: 412

Member Since:
December 20, 2019

Offline

July 5, 2020 - 2:11 am

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)

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