The basic formula: dividing the part by the whole

To find what percentage one number is of another in Excel, divide the smaller number by the larger number, then multiply by 100. If you want to know what percentage 25 is of 200, you divide 25 by 200 to get 0.125, then multiply by 100 to get 12.5%.

In Excel, you enter this as a formula in a cell. Type =25/200*100 and press Enter. The cell shows 12.5. You can also reference cells instead of typing numbers directly — if 25 is in cell A1 and 200 is in cell B1, you type =A1/B1*100.

Most people skip the *100 step and instead format the cell as a percentage after the division. Type =A1/B1, press Enter, then right-click the cell and choose Format Cells. Select Percentage from the Category list and click OK. Excel multiplies by 100 and adds the % symbol automatically, so the cell displays 12.5% instead of 0.125.

Key Takeaways

  • The percentage formula is the part divided by the whole: =A1/B1 where A1 is the smaller amount and B1 is the total.
  • You can multiply the result by 100 in the formula itself, or format the cell as a percentage to let Excel handle the multiplication.
  • Percentage formatting shows one or two decimal places by default, but you can right-click and adjust decimal places if you need more or fewer.
  • The same formula works for any row of data — copy the formula down and Excel adjusts the cell references automatically for each row.
  • If your formula shows a decimal like 0.125 instead of 12.5%, the cell is formatted as a number rather than a percentage.

Copying the formula down for multiple rows

When you have a list of amounts and want to calculate the percentage for each one, you enter the formula once, then copy it down. Put your data in columns — say column A holds individual amounts and column B holds the total. In cell C1, type =A1/B1 and press Enter.

Click on cell C1 to select it. Move your cursor to the small square in the bottom-right corner of the cell until it changes to a plus sign, then click and drag down to the last row of your data. Excel copies the formula and adjusts the row numbers automatically — C2 becomes =A2/B2, C3 becomes =A3/B3, and so on.

If you have 50 rows, dragging is slow. Instead, click C1, copy it (Ctrl+C on Windows or Command+C on Mac), then select the range C1:C50 and paste (Ctrl+V or Command+V). Excel fills the entire range with the formula, adjusting each row.

Formatting cells as percentages

After you enter your formula, the cell usually shows a decimal — 0.125 instead of 12.5%. To display it as a percentage, right-click the cell and select Format Cells. In the window that opens, click the Number tab if it is not already selected, then choose Percentage from the Category list on the left.

You will see a Decimal Places field, usually set to 2. This controls how many digits appear after the decimal point in your percentage. Leave it at 2 for most purposes, or change it to 0 if you want whole numbers only (12% instead of 12.50%), or to 3 if you need more precision.

A faster way: select the cell or range, then look for the percentage button (%) in the toolbar at the top of the screen. Click it and Excel formats the selection as a percentage with two decimal places. This is the quickest route if you do not need to adjust decimal places.

Calculating percentage increase or decrease

Percentage increase and decrease use a slightly different formula. To find how much a number has grown or shrunk, subtract the original value from the new value, divide by the original value, then multiply by 100. If a price was $50 and is now $75, the increase is (75 − 50) ÷ 50 × 100, which equals 50%.

In Excel, type =(B1-A1)/A1*100 where A1 is the original amount and B1 is the new amount. Or use =(B1-A1)/A1 and format as a percentage. If the result is negative, the amount decreased rather than increased.

A common mistake is dividing by the new value instead of the original. The formula must always divide by the starting point, not the ending point, or your percentage will be wrong.

Avoiding common mistakes

The most frequent error is reversing the division — putting the whole in the numerator and the part in the denominator. If you want to know what percentage 25 is of 200, you must divide 25 by 200, not 200 by 25. Dividing backwards gives you 8 instead of 12.5, which is a significant difference.

Another mistake is forgetting to lock the denominator when you copy a formula down. If column B holds a total that should stay the same for all rows, you need to lock that cell reference. Instead of =A1/B1, type =A1/$B$1. The dollar signs tell Excel to keep B1 fixed when you copy the formula down — it becomes =A2/$B$1, =A3/$B$1, and so on, rather than =A2/B2, =A3/B3.

If your formula shows an error like #DIV/0!, it means you are dividing by zero or an empty cell. Check that the denominator cell contains a number and is not blank.

Using the formula with real data

Suppose you have a budget spreadsheet. Column A lists expense categories, column B shows the amount spent in each category, and column C shows your total budget. You want column D to show what percentage of the total budget each expense represents.

In cell D1, type =B1/$C$1. The dollar signs lock the total budget so it does not change when you copy down. Press Enter, then format the cell as a percentage. Copy the formula down to all rows with data. Each row now shows what percentage that expense is of your total budget.

If you want to see the percentage of a subtotal instead — say, what percentage of your food budget went to groceries — use the same formula but reference the subtotal cell instead of the grand total. The structure stays the same: part divided by whole.

Frequently Asked Questions

Why does my formula show 0.125 instead of 12.5%?

The cell is formatted as a number instead of a percentage. Right-click the cell, select Format Cells, choose Percentage from the Category list, and click OK. Excel will multiply by 100 and display the % symbol.

How do I calculate what percentage of a total each item represents?

Divide each item by the total using =A1/$B$1, where A1 is the item and $B$1 is the total (the dollar signs keep the total fixed when you copy down). Format as a percentage. All items should add up to 100%.

What is the difference between percentage and percentage point?

A percentage point is the difference between two percentages. If something goes from 20% to 25%, it increased by 5 percentage points, but the percentage increase is 25% (because 5 ÷ 20 × 100 = 25). Most people mean percentage when they say percentage point, but the distinction matters in precise contexts.

Can I calculate percentage in a single cell without copying down?

Yes. If you have one amount in A1 and one total in B1, type =A1/B1 in any empty cell, press Enter, and format as a percentage. You do not need multiple rows to use the formula.

What does the $ symbol do in a formula?

The $ symbol locks a cell reference so it does not change when you copy the formula. $B$1 stays as B1 in every copy. B$1 locks only the row, so the column changes. $B1 locks only the column, so the row changes. Use $B$1 when you want the reference to stay exactly the same.