Excel's Percentage number format multiplies the cell value by 100 and displays the % symbol. So, for example, if you apply the Percentage number format to a cell containing 0.54, the cell will ...

Master Excel Percentage Calculations with the help of our in-depth articles and helpful guides. Mastering Budget vs Actual Analysis with Excel Functions Apple’s iOS 6 Is On 93 Percent Of iPhones ...

Now as you can see in the image, the average comes to 80.85, which is the correct result. This is all about how to calculate weighted average in Excel with percentages. I hope you find this helpful.