Any Microsoft Excel (2007) wizards on here?

tonyq

tonyq

Suspended / Banned
Messages
236
Edit My Images
Yes
Hi all.
I need to find 4 percentages of 4 different numbers in different columns e.g.

25% of 10 in cell A1, 20% of 20 in cell B1, 15% of 30 in cell C1, 10% of 40 in cell D1

Then add the answers together in a different cell eg cell E1

Can this be done ?
 
E1 should be =(0.25*A1)+(0.2*B1)+(0.15*C1)+(0.1*D1)

HTH
 
For another option...
If you want to the ability to change the percentages, rather than hard coding them in the formulae, put the percentages in row 2. Then at the end of row 2 (assuming you only have data in columns a to d)
=SUMPRODUCT (a1:d1, a2:d2)

but the excel purist in me would build the table in rows rather than columns!
 
Rapscallion said:
For another option...
If you want to the ability to change the percentages, rather than hard coding them in the formulae, put the percentages in row 2. Then at the end of row 2 (assuming you only have data in columns a to d)
=SUMPRODUCT (a1:d1, a2:d2)

but the excel purist in me would build the table in rows rather than columns!
Click to expand...

Exactly right :)

Though if I *had* to use rows like that I'd move row 1 to row 2 and put the percentages in row 1 so I could run some comparative analysis on what happens if the numbers in row 2 change.
 
Update, I have placed the data in rows rather than columns has suggested giving a try, which seems a better option for what I want. Thank you all for your help. Sorry for the delay in replying.
 
You must log in or register to reply here.
Back
Top