How to Calculate Percentages in Excel

Understanding how a portion relates to a whole is a fundamental requirement in business and personal finance. Whether you are calculating the tax on a purchase, determining what percentage of your monthly budget is consumed by rent, or analyzing the profit margin on a sale, percentages provide immediate context that raw numbers lack. Microsoft Excel handles percentage calculations brilliantly, but unlike typing a simple addition formula (e.g., =5+5), calculating percentages requires an understanding of how Excel formats numbers and basic mathematical division.

The Fundamental Math Formula

In mathematics, calculating a percentage is always a division problem followed by a multiplication: (Part / Total) x 100. For example, if you scored 45 out of 50 on a test, the math is (45 / 50) x 100 = 90%. In Excel, however, you do not multiply by 100 in the formula. You simply perform the division (Part / Total), which yields a decimal (e.g., 0.90). You then use Excel’s built-in formatting tools to visually convert that decimal into a percentage.

Step-by-Step: Finding the Percentage of a Total

Let’s assume you want to calculate your rent percentage. In cell A1, you have your monthly rent ($1,500). In cell B1, you have your total monthly income ($5,000).

1. Click on an empty cell where you want the percentage to appear (e.g., cell C1).
2. Type an equals sign = to start the formula.
3. Click on cell A1 (the “part” or smaller number).
4. Type a forward slash /, which is the symbol for division in Excel.
5. Click on cell B1 (the “total” or larger number).
6. Your formula should look like this: =A1/B1. Press Enter.
7. Cell C1 will now display the decimal 0.3.
8. To convert this decimal into a readable percentage, click back onto cell C1.
9. Navigate to the Home tab on the ribbon.
10. In the ‘Number’ group, click the Percent Style button (%). Alternatively, you can use the keyboard shortcut Ctrl + Shift + %.

The cell will instantly change from 0.3 to 30%.

Step-by-Step: Calculating Percentage Change (Growth or Decline)

Another common task is calculating how much a number has grown or shrunk. For example, if sales were $10,000 in January and $12,000 in February, what is the percentage increase?

The formula for percentage change is: (New Value – Old Value) / Old Value.

1. Assume January sales ($10,000) are in cell A1, and February sales ($12,000) are in B1.
2. Click an empty cell (C1) and type: =(B1-A1)/A1. (Note: The parentheses are absolutely critical here; they force Excel to subtract before it divides).
3. Press Enter. You will get the decimal 0.2.
4. Click cell C1 and click the Percent Style button (%) on the Home tab. The cell will read 20%.

By mastering basic division and relying on Excel’s formatting tools, complex financial analysis becomes a simple task.