PDA

View Full Version : Problem with formula



arnab0711
04-27-2012, 12:53 AM
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.

shrivallabha
04-27-2012, 10:46 AM
Hi,

Your calculation formula in merged cell B11 differs with what is written here (http://support.microsoft.com/kb/214049).

See attached file. Is this what you are after?