Formula help, please

[R0nseal]

Hi All,

Not sure how to explain this too well but here goes...

I have a SS much like the below example, where i have a list of peoples incomes, in this example, 100 & 100. I then have a field with a total of expenses, in this example, 500. I then use a formula as shown below, which looks at that specific persons income and the total of all peoples incomes to let me know the proportion of that persons income out of them all added together, giving me the % out of 100. My problem is, I use the following formula: =$G$2*0.50, to look at the total expenses, in this example in G2, the amount of 500, and then work out the proportion based on the income proportion. But I have to manually type in the formula in E2 with the proportion D2 gas given me, my question is, is there a way i can make E2 automatically change the end of the formula to whatever D2 is giving me a answer for? In this example it would be 50%



[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD]Income[/TD]
[TD][/TD]
[TD]Proportion of income %[/TD]
[TD]Expense proportioned out[/TD]
[TD][/TD]
[TD]Expenses[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD]100[/TD]
[TD][/TD]
[TD]=B2/$B$4*100[/TD]
[TD]??
=$G$2*0.50[/TD]
[TD][/TD]
[TD]500 [/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD]100[/TD]
[TD][/TD]
[TD]=B3/$B$4*100[/TD]
[TD]??[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Total[/TD]
[TD]200[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

How do i make the bold section of formula above, auto change to the answer given in cell D2??

Thank you!!

 

[Fluff]

How about

Excel 2013 32 bit
	A	B	C	D	E	F	G
1		Income		Proportion of income %	Expense proportioned out		Expenses
2		100		50%	250		500
3		100		50%	250
4	Total	200
AL7 3JH

Cell Formulas
Range	Formula
D2	=B2/$B$4
E2	=$G$2*D2

 

[r1998]

Hello
use this formula in e2 and drag down till e3

=$G$2*D2%