The basic percentage formula in Excel

To calculate a percentage in Excel, divide the part by the whole, then multiply by 100. The formula is =(part/whole)*100. If you want the result to display as a percentage without multiplying by 100, use =(part/whole) and format the cell as a percentage instead.

For example, if you sold 45 items out of 200 total items, click the cell where you want the answer. Type =45/200 and press Enter. Excel shows 0.225. Right-click that cell, select "Format Cells", choose "Percentage" from the Category list, and click OK. The cell now displays 22.5%.

The second method is cleaner when you are building a spreadsheet you will use repeatedly. The first method (multiplying by 100) is useful when you need the number itself rather than a formatted cell — for instance, if you are writing the result into a sentence or comparing it to a threshold.

Key Takeaways

  • The percentage formula is =(part/whole)*100 for a decimal result, or =(part/whole) formatted as percentage for a cleaner display.
  • You can reference cell addresses instead of typing numbers, so =(B2/B3)*100 will calculate the percentage of whatever is in those cells.
  • Use absolute references with dollar signs (like $B$3) when you want to divide multiple rows by the same total without the reference shifting.
  • The fill-down feature copies a formula to many cells at once, which saves time when calculating percentages for an entire column of data.

Using cell references instead of typing numbers

When your data lives in cells rather than as typed numbers, reference those cells in your formula. If cell B2 contains 45 and cell B3 contains 200, type =B2/B3 in the cell where you want the percentage. Excel calculates the division and shows 0.225. Format that cell as a percentage to display 22.5%.

This approach matters because if the numbers in B2 or B3 change later, the percentage updates automatically. You do not have to retype the formula. This is especially useful in budgets, sales tracking, or any spreadsheet where the raw numbers shift over time.

Calculating percentage change between two numbers

Percentage change shows how much something grew or shrank. The formula is =((new value - old value) / old value) * 100. If a product cost $40 last month and costs $50 this month, the percentage increase is =((50-40)/40)*100, which equals 25%.

You can also write this as =(B2-B1)/B1 if B1 holds the old value and B2 holds the new value, then format the result as a percentage. If the result is negative, the value decreased. A result of -10% means the value dropped by 10%.

Copying the formula down to multiple rows

When you have a list of items and need to calculate the percentage for each one, you do not type the formula into every cell. Instead, type it once, then use fill-down to copy it to the rest of the column. Click the cell with your formula, then drag the small square at the bottom-right corner of the cell down to the last row you need. Excel copies the formula and adjusts the cell references automatically.

For example, if your formula in C2 is =B2/B3, dragging down to C10 creates formulas in C3 through C10 that read =B3/B4, =B4/B5, and so on. Each row calculates its own percentage using the numbers in that row.

Using absolute references to divide by a single total

Sometimes you want to divide many different numbers by the same total. If you have sales for each month in column B and the annual total in cell B13, you want each month to divide by B13 — but when you copy the formula down, Excel normally shifts B13 to B14, B15, and so on, which is wrong.

To lock a cell reference so it does not shift, add dollar signs: =$B$13. The formula =B2/$B$13 in cell C2 will copy down as =B3/$B$13, =B4/$B$13, and so on. The B13 reference stays fixed while the B2 reference shifts to match each row. This is called an absolute reference, and it is essential when you are dividing a column of items by a single total.

Calculating what percentage one number is of another

This is the most common percentage question: "What percentage of the budget did we spend?" or "What share of total sales came from this region?" The formula is =(part/total)*100 or =(part/total) formatted as percentage.

If your company budgeted $50,000 and spent $37,500, the percentage spent is =(37500/50000)*100, which equals 75%. If you have these numbers in cells, use =B2/B3 instead. Format the result as a percentage to display 75% rather than 0.75.

Displaying percentages with the right number of decimal places

By default, Excel may show percentages with many decimal places (22.50%) or none at all (23%), depending on your settings. To control this, right-click the cell with your percentage, select "Format Cells", choose "Percentage" from the Category list, and change the "Decimal places" field to the number you want.

For most business uses, one or two decimal places is standard. Sales percentages often show zero decimal places (75%), while financial analysis might show two (22.50%). Choose what makes sense for your data. You can format multiple cells at once by selecting them all before opening the Format Cells dialog.

Frequently Asked Questions

Should I multiply by 100 in the formula or format the cell as a percentage?

Formatting is cleaner and more professional. Use =(part/whole) and format the cell as percentage. This way, if you change the decimal places later, the display updates automatically. Multiplying by 100 in the formula is useful only if you need the actual number 75 rather than the formatted display 75%.

Why does my percentage show as a decimal like 0.225 instead of 22.5%?

The formula calculated correctly, but the cell is not formatted as a percentage. Right-click the cell, select "Format Cells", choose "Percentage", and click OK. The same number now displays as 22.5%. You can also click the percentage button (%) in the toolbar if your version of Excel has one.

How do I calculate what number is 25% of 200?

Use the formula =200*0.25 or =200*25%. Both equal 50. If the 200 is in cell B2, type =B2*0.25. This is the reverse of the percentage calculation — instead of finding what percentage one number is of another, you are finding what number corresponds to a given percentage.

Can I use percentage formulas in a pivot table?

Yes. In a pivot table, right-click a value, select "Show Values As", and choose "% of Grand Total" or another percentage option. Excel calculates the percentages for you without needing a separate formula. This is faster than building formulas manually when you are working with large datasets.

What does the error #DIV/0! mean when I calculate a percentage?

This error means you are dividing by zero or by an empty cell. Check that the cell in the denominator (the bottom number) contains a value and is not zero. If it is supposed to be empty sometimes, use =IFERROR(B2/B3,0) to display 0 instead of an error when the denominator is empty.