Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set up a weighted formula in Excel?
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set up a weighted formula in Excel?
On Mon, 10 May 2010 15:53:01 -0700, ib1qb
wrote: 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? =sumproduct(numbers, weights) e.g. =sumproduct(a1:a2,{0.9,0.1}) --ron |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set up a weighted formula in Excel?
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 "ib1qb" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for weighted voting/scoring | Excel Discussion (Misc queries) | |||
Formula for Weighted Average | Excel Discussion (Misc queries) | |||
weighted formula | Excel Discussion (Misc queries) | |||
Moving Weighted Average formula | Excel Discussion (Misc queries) | |||
What is the formula for weighted average? | Excel Worksheet Functions |