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
|