#### R0nseal

##### Board Regular
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%

 A B C D E F G 1 Income Proportion of income % Expense proportioned out Expenses 2 100 =B2/\$B\$4*100 ?? =\$G\$2*0.50 500 3 100 =B3/\$B\$4*100 ?? 4 Total 200 5

<tbody>
</tbody>

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

Thank you!!

### Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use \$ signs: \$V\$2:\$Z\$99 will always point to V2:Z99, even after copying

#### Fluff

##### MrExcel MVP, Moderator

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:

#### r1998

##### Board Regular
Hello
use this formula in e2 and drag down till e3
Code:
``=\$G\$2*D2%``

Last edited:

Replies
0
Views
115
Replies
1
Views
82
Replies
2
Views
334
Replies
4
Views
165
Replies
4
Views
127

1,181,847
Messages
5,932,437
Members
436,838
Latest member
rparthireddy

### 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.

### Which adblocker are you using?

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

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