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%



ABCDEFG
1IncomeProportion of income %Expense proportioned outExpenses
2100=B2/$B$4*100??
=$G$2*0.50
500
3100=B3/$B$4*100??
4Total200
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
Joined
Jun 12, 2014
Messages
79,840
Office Version
  1. 365
Platform
  1. Windows
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:

r1998

Board Regular
Joined
Sep 9, 2018
Messages
106
Hello :)
use this formula in e2 and drag down till e3
Code:
=$G$2*D2%
 
Last edited:

Forum statistics

Threads
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.
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
Top