How To Calculate Percentages In Excel
We’re using Excel 2010 here, but it’s the same process in any version of Excel since only basic fomulae are used. While you could tap in the figures on a calculator, Excel allows you to calculate percentages on multiple figures extremely quickly. How to calculate percentages in Excel When you have the amount and total If you have a total, and you want to calculate the percentage of a certain amount below this total, here’s the calculation: Amount / total = percentage We’ll use the UK referendum figures for this example....