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. For example, if you want to find what percentage 25 is of 200, you would enter =​(25/200)*100 in a cell, and Excel returns 12.5.

You can also skip the multiplication by 100 and format the cell as a percentage instead. Enter =25/200, then right-click the cell, select Format Cells, choose Percentage, and click OK. Excel automatically displays the result as 12.5% without the extra multiplication step.

Most people find the second method cleaner because it separates the math from the display. The formula stays simple, and the percentage format handles the visual presentation.

Key Takeaways

  • The percentage formula is =(part/whole)*100, or you can divide and format the cell as a percentage.
  • Use dollar signs ($) around cell references when you want to copy a formula down a column without the references changing.
  • To calculate a percentage increase or decrease, use =((new value - old value)/old value)*100.
  • The percentage of a total works by dividing each item by the sum of all items, then formatting as percentage.

Calculating What Percentage One Number Is of Another

This is the most common percentage task. You have two numbers and want to know the relationship between them. If your part is in cell A1 and your whole is in cell B1, enter =A1/B1 and format as percentage. If A1 contains 50 and B1 contains 200, the result shows 25%.

When you need to copy this formula to other rows, use absolute references for the whole if it stays the same. For example, if you are calculating what percentage each sales figure is of a total that appears in cell B10, write =A1/$B$10. The dollar signs lock B10 in place, so when you copy the formula down, A1 becomes A2, A3, and so on, but B10 stays B10.

Calculating Percentage Increase or Decrease

To find how much a number has grown or shrunk as a percentage, subtract the old value from the new value, divide by the old value, then multiply by 100. The formula is =((new-old)/old)*100. If a price went from $80 to $100, the calculation is =((100-80)/80)*100, which returns 25%.

A negative result means a decrease. If the price dropped from $100 to $80, the formula =((80-100)/100)*100 returns -20%, showing a 20% decline. This formula works for any values: revenue, inventory, website traffic, or test scores.

Finding a Percentage of a Total

When you have a list of items and want to see what percentage each one represents of the total, divide each item by the sum of all items. If your items are in cells A1 through A10, the formula for the first item is =A1/SUM($A$1:$A$10). Format the column as percentage, then copy the formula down.

The dollar signs around the SUM range keep that range locked while the A1 reference changes to A2, A3, and so on as you copy down. This is useful for breaking down a budget by category, showing each product's share of total sales, or displaying how much time each task took as a percentage of the total project time.

Using Percentage to Calculate a Portion of a Number

Sometimes you know the percentage and want to find the actual amount. If an item costs $200 and you want to calculate a 15% discount, use =200*0.15 to get $30. You can also write =200*15% and Excel understands the percentage symbol.

To find the final price after the discount, use =200-200*0.15 or =200*(1-0.15). The second version is cleaner because it calculates the result in one step: multiply the original price by 85% (which is 100% minus the 15% discount).

Common Mistakes to Avoid

The most frequent error is forgetting to format cells as percentage after dividing. If you enter =25/200 and leave the cell formatted as a number, you see 0.125 instead of 12.5%. The math is correct, but the display is confusing. Always format the result column as percentage when that is what you are showing.

Another mistake is using the wrong reference when copying formulas. If you want the denominator to stay the same across all rows, add dollar signs: $B$1. If you forget, Excel adjusts both the numerator and denominator as you copy, giving wrong results. Test your formula on the first row, then copy it down to check that the results make sense.

Mixing up percentage increase and percentage of total is also common. Percentage increase compares a new value to an old value. Percentage of total compares one item to the sum of all items. They use different formulas and answer different questions.

Formatting Percentages for Clarity

After you calculate percentages, you can control how many decimal places appear. Right-click the cells, select Format Cells, choose Percentage, and set the decimal places to 0, 1, 2, or however many you need. Most business reports use 1 or 2 decimal places; scientific work might use more.

You can also use conditional formatting to highlight percentages that meet certain conditions. For example, highlight all percentages above 50% in green and below 50% in red. Select the cells, go to Home > Conditional Formatting, choose a rule, and set your thresholds. This makes patterns in your data easier to spot at a glance.

Frequently Asked Questions

What is the difference between multiplying by 100 and formatting as percentage?

Multiplying by 100 changes the actual value in the cell (0.125 becomes 12.5). Formatting as percentage keeps the value as 0.125 but displays it as 12.5%. Both show the same result, but formatting is cleaner because your formulas stay simple and you can change the display without recalculating.

How do I calculate what percentage of my budget each expense is?

Divide each expense by the total budget, then format as percentage. If expenses are in A1:A5 and the total is in A6, use =A1/$A$6 for the first expense, then copy down. The dollar signs keep A6 locked so each expense divides by the same total.

Can I show percentages with a % symbol without formatting the whole cell?

Yes. If you want the value 12.5 to display as "12.5%", use =TEXT(A1,"0.0%"). This converts the number to text with the symbol attached. The downside is you cannot use the result in further calculations because it becomes text instead of a number.

What does a negative percentage mean?

A negative percentage in a percentage change formula means a decrease. If revenue was $1000 last month and $800 this month, the percentage change is -20%, showing a 20% drop. In other contexts, negative percentages are rare and usually indicate an error in your formula or data.

How do I calculate a running total as a percentage?

Divide each running total by the final total. If your running totals are in column B and the final total is in B10, use =B1/$B$10 for the first row and copy down. This shows what percentage of the final total you have reached at each point.