I have 3 employees, Tracy, Buzz and Damon they work as a team,
If they all work the same amount of days there wages are as follows
Tracy gets 47% of the total
Buzz gets 33% of the total
And Damon gets 20% of the total
But what happens in the scenario below
Name Days total price total day rate total earnings
worked work for team for team for team
Tracy 7 =A31500.00 =A3350.00 =A31850.00
Buzz 5
Damon 3
How much would each member earn and i need a formula so i can change
details in each column
Your help would be most appreciated
Bookmarks