weighted average problem

[arnab0711]

Hi,
I have this excel sheet where I have 3 qty and 3 rates and an weighted average,my question is If I have 2 qty by what rate should I multiply both the qty to arrive at the total.

[tigertiger]

Hi,
I have this excel sheet where I have 3 qty and 3 rates and an weighted average,my question is If I have 2 qty by what rate should I multiply both the qty to arrive at the total.

There is some results for yr conditions
For example,

(1) the 1st result - equal rate
+ at G4, fill the formula
=$B$11/$F$6
+copy for G5

(2) the 2rd result - weigh of distributions from the 3rd (off) one
+ at G4, fill the formula
=($C$6*(F4-B4)+B4*C4)/F4
+copy for G5

(3) and of course, there exists other appropriate results
---------

the second (2) one may be appropriate solution as you need