|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 10th, 2010, 11:53 PM
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
May 11th, 2010, 01:05 AM
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
May 11th, 2010, 01:27 AM
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?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
