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.
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.
Hi,
Your calculation formula in merged cell B11 differs with what is written here.
See attached file. Is this what you are after?
Regards,
--------------------------------------------------------------------------------------------------------
Shrivallabha
--------------------------------------------------------------------------------------------------------
Using Excel 2016 in Home / 2010 in Office
--------------------------------------------------------------------------------------------------------