How do I set up a weighted formula in Excel?

  • Thread starter Thread starter ib1qb
  • Start date Start date
I

ib1qb

Can someone help me please? I need to do a weighted formula in Excel 2007,
where the total of the numbers equals 90% of one number and 10% of another
number. Is it possible to do this?
 
Can someone help me please? I need to do a weighted formula in Excel 2007,
where the total of the numbers equals 90% of one number and 10% of another
number. Is it possible to do this?
Click to expand...

=sumproduct(numbers, weights)

e.g.

=sumproduct(a1:a2,{0.9,0.1})

--ron
 
Sa g1 to j7 contains:

Units Qty Cost Sales
Item 1 90 10 900
Item 2 10 20 200
Totals 100 1100
Wgt Cost1 11
Wgt Cost2 11

The formula in I6 is =(0.9*I2)+(0.1*I3) [q1 * p1]+ [q2 * p2]

We can use this because you already told us that the qtys were in the
proportion 90% and 10%

If you had not given us this information we would have to use this formula
in I7

=(H2*I2+H3*I3)/(H2+H3)

(p*q+p1*q1)/(q+q1)

HTH
Peter
 
Back
Top