Divide amount between group of people with various workload

[Refreshed78]

Hi all,

Thanks for having me in this forum! I have a problem that I can't figure out how to create a formula for in Excel.
Let's say I have an amount of X that should be divided Y people. 3 of these people work 100% so should have a full share the other 7 work 70% and should have a share equal to 70% of a full share.
So I need to know what amount each person gets according to their share and workeffort.

Was hoping to create something like this, where values in row 2 can be updated and line D3/D4 and E3/E4 get updated accordingly.
The amounts below are all calculated manually as I couldn't figure out how to do it otherwise. =)

Would really apreciate the help!

Kind regards,
Refreshed78

 

[Eric W]

Welcome to the MrExcel forum!

Try:

Book1
	A	B	C	D	E
1		Amount	Total Users	Users working 100%	Users working 70%
2		1100	9	3.00	6.00
3	Total amount per group			458.33	641.67
4	Total amount per user			152.78	106.94
Sheet1

Cell Formulas
Range	Formula
D3:E3	D3	=D2*D4
D4	D4	=B2/(D2+0.7*E2)
E4	E4	=D4*0.7