Formula help, please

R0nseal

Board Regular
Joined
Aug 25, 2015
Messages
103
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!!
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.
How about


Excel 2013 32 bit
ABCDEFG
1IncomeProportion of income %Expense proportioned outExpenses
210050%250500
310050%250
4Total200
AL7 3JH
Cell Formulas
RangeFormula
D2=B2/$B$4
E2=$G$2*D2
 
Last edited:
Upvote 0
Hello :)
use this formula in e2 and drag down till e3
Code:
=$G$2*D2%
 
Last edited:
Upvote 0

Forum statistics

Threads
1,223,893
Messages
6,175,244
Members
452,622
Latest member
Laura_PinksBTHFT

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top