The basic formula: divide the part by the whole, then multiply by 100

To calculate what percentage one number is of another in Excel, you divide the smaller number by the larger number and multiply the result by 100. If you want to know what percentage 25 is of 200, you would enter =25/200*100 into a cell, which gives you 12.5.

Excel also has a built-in percentage format that does the multiplication by 100 for you automatically. If you enter =25/200 and then format that cell as a percentage, Excel displays the same result — 12.5% — without you typing the *100 part. This second method is faster once you get used to it.

The formula works the same way regardless of whether your numbers are typed directly into the cell or are references to other cells. If your part is in cell A1 and your whole is in cell B1, you would write =A1/B1*100 or =A1/B1 with percentage formatting.

Key Takeaways

  • The percentage formula is always: (part ÷ whole) × 100, or just (part ÷ whole) if you format the result as a percentage.
  • You can type numbers directly into the formula or reference cells containing numbers using their letter-number coordinates.
  • Percentage formatting in Excel automatically multiplies by 100, so you only need to divide when using it.
  • The same formula works for calculating what percentage of a budget was spent, what portion of a goal was reached, or any other part-to-whole comparison.

Using cell references instead of typing numbers directly

When your numbers live in different cells, referencing them keeps your formula flexible. If you have a sales target in B2 and actual sales in B3, you can write =B3/B2*100 to see what percentage of your target you hit. If the actual sales number changes later, the percentage updates automatically without you retyping the formula.

This matters especially when you are building a spreadsheet that other people will use or that you will update regularly. A formula that points to cells is much easier to maintain than one with numbers hardcoded in. You can also copy the formula down a column to calculate percentages for multiple rows at once.

Formatting cells as percentage to skip the *100 step

Excel's percentage format is a shortcut that saves you from typing *100 every time. After you enter a formula like =A1/B1, right-click the cell, choose Format Cells, select Percentage from the Category list, and click OK. The cell now displays the result as a percentage without changing the formula itself.

By default, percentage formatting shows two decimal places. If you want more precision or fewer decimals, you can adjust this in the same Format Cells dialog. Some people prefer to see whole numbers only (12% instead of 12.50%), while others need the decimal detail. The choice depends on what your data represents.

Calculating percentage increase or decrease between two numbers

When you want to know how much a number has grown or shrunk as a percentage, the formula changes slightly. You subtract the original number from the new number, divide by the original, and multiply by 100. The formula is =(new-old)/old*100.

If a product cost $50 last month and costs $60 now, you would calculate =(60-50)/50*100, which gives you 20%. That means the price increased by 20%. If the price had dropped to $40, the formula would give you -20%, showing a decrease. The negative sign tells you the direction of the change.

Building a percentage breakdown of a total

When you have multiple items that add up to a total and want to see what percentage each one represents, use the same basic formula but always divide by the total. If you have expenses in cells A2 through A5 and the total in A6, you would write =A2/$A$6*100 for the first item.

Notice the dollar signs around A6: $A$6. These absolute references lock that cell so it does not change when you copy the formula down. Without them, if you copy the formula to the next row, it would try to divide by A7 instead of staying with A6. With absolute references, every row divides by the same total.

After entering the formula for the first item, click the cell and drag the small square at the bottom-right corner down to the other rows. Excel copies the formula and adjusts only the part that should change (A2 becomes A3, A4, and so on) while keeping A6 locked.

Common mistakes and how to avoid them

The most frequent error is dividing in the wrong direction. If you want to know what percentage 25 is of 200, you divide 25 by 200, not 200 by 25. Reversing this gives you 800% instead of 12.5%. A quick sanity check: your answer should be smaller than 100% if the part is smaller than the whole.

Another common mistake is forgetting to use absolute references when copying a formula across multiple cells. If you copy =A2/A6*100 down without the dollar signs, the second row tries to divide by A7, which is wrong. Always use $A$6 when you want a cell to stay the same across all copies.

People also sometimes multiply by 100 and then apply percentage formatting, which multiplies by 100 again and gives a result 100 times too large. If you use percentage formatting, do not include *100 in your formula. If you include *100, do not format as percentage.

Using percentage formulas in real spreadsheets

A budget tracker might have categories in column A, budgeted amounts in column B, and actual spending in column C. You can add a column D with the formula =C2/B2 formatted as percentage to show what portion of each budget was spent. This lets you spot categories where you are over or under budget at a glance.

A sales spreadsheet might track monthly revenue in column B and a yearly target in a single cell. You would use =B2/$B$13*100 (if the target is in B13) to calculate what percentage of the annual goal each month represents. This helps you see whether you are on pace to hit the target by year end.

A student grade tracker could calculate what percentage of total points a student earned. If possible points are in column B and earned points are in column C, the formula =C2/B2 with percentage formatting shows the grade as a percentage. You can copy this formula down for every student without retyping.

Frequently Asked Questions

Do I have to multiply by 100 if I use percentage formatting?

No. If you format a cell as percentage, Excel multiplies by 100 for you. Use either =A1/B1*100 without percentage formatting, or =A1/B1 with percentage formatting. Using both gives you a result 100 times too large.

What does the dollar sign do in a formula like $A$6?

The dollar signs lock that cell reference so it does not change when you copy the formula to other rows or columns. Without them, Excel adjusts the reference automatically. Use dollar signs when you want a cell to stay the same across all copies of the formula.

How do I calculate percentage increase or decrease?

Use the formula =(new-old)/old*100. Subtract the original number from the new number, divide by the original, and multiply by 100. A positive result means an increase; a negative result means a decrease.

Can I calculate percentages if my numbers are in different sheets?

Yes. Reference another sheet by typing the sheet name followed by an exclamation point and the cell, like =Sheet2!A1/Sheet1!B1*100. Excel treats it the same as a regular cell reference.

What if I want to round my percentage to a whole number?

Wrap your formula in the ROUND function: =ROUND(A1/B1*100,0). The 0 at the end tells Excel to round to zero decimal places. Use 1 for one decimal place, 2 for two, and so on.