Find a Percentage in Excel: Formulas, Examples, and Tips

Formulas & functions · Updated November 20, 2026

To find what percentage one value is of another in Excel, divide the part by the total, then format the result as a percentage. For example, if B2 contains 18 and C2 contains 24, enter =B2/C2 in D2; the result is 0.75, which displays as 75% after percentage formatting. You can use the same approach to find a percentage of a total, calculate a percent change, or work out a percentage of an amount.

Before you start, decide what you mean by finding a percentage: comparing a part with a whole, calculating a percentage amount, or measuring how much a value changed. The formulas differ slightly, but all use ordinary Excel arithmetic. The examples below are for Microsoft Excel for Microsoft 365 on Windows. The calculations work in Excel for Mac and Excel for the web too, though ribbon layout can vary slightly.

What You’ll Need

  • An Excel workbook with the values you want to compare or calculate.
  • A clear understanding of which number is the part, total, starting value, or percentage rate.
  • A blank cell for the result. Percentage formatting is useful for readability but is not required for the calculation itself.

Step-by-Step

  1. Choose the percentage calculation you need. If you want to know what share a number is of a total, divide the part by the total. To calculate a percentage of an amount, multiply the amount by the rate. To measure an increase or decrease, compare the difference with the starting value. Identifying the question first helps you put the correct value in the numerator or denominator.
  2. Arrange the values and label them. Use one cell for each input and add labels such as Part, Total, and Percentage. For the basic share example, enter 18 in B2 and 24 in C2; label B1 Part, C1 Total, and D1 Percentage. Labels make it easier to check the setup later, especially when a workbook contains many rows.
  3. Divide the part by the total. With the part in B2 and the total in C2, select D2 and enter =B2/C2. Press Enter. The result is 0.75 because 18 divided by 24 equals 0.75. This is the underlying decimal value for 75%; it is not an error if Excel initially shows 0.75.
  4. Format the result as a percentage. Select D2, then choose Home > Number > Percent Style (%). Excel displays 0.75 as 75%. You can also use the Increase Decimal or Decrease Decimal buttons in the Number group to control how many decimal places appear. Formatting changes the display, not the calculation stored in the cell.
  5. Check the part and total before copying. Confirm that the total is the complete group the part belongs to, and that the total is not zero or blank. A part of 18 out of a total of 24 is 75%; a part of 24 out of 18 would be 133.33%, which may be mathematically valid but could indicate that the values were reversed for your question.
  6. Calculate each row in a list. Suppose parts are in B2:B5 and the same overall total is in C2. To calculate the first row, enter =B2/$C$2 in D2. Here, the part is in B2 and the fixed total is in C2. The dollar signs make C2 an absolute reference, so it stays fixed when the formula is copied. If B2 is 12 and C2 is 25, the result is 48%.
  7. Fill the formula down for other parts. Select D2 and drag the small fill handle at the lower-right corner of the cell down through D5, or copy D2 and paste it into D3:D5. Excel updates B2 to B3, B4, and B5 while keeping the total reference at $C$2. Format the whole result range as percentages if the pasted cells do not already have percentage formatting.
  8. Find a percentage of an amount. If A2 contains an amount of 80 and B2 contains a rate of 20%, select C2 and enter =A2*B2. The formula multiplies the amount by the rate, so 80 multiplied by 20% returns 16. Format C2 as Currency if you want the result to display as an amount; the calculation itself does not require currency formatting. This example is for illustrating Excel arithmetic, not financial advice.
  9. Calculate the percentage increase or decrease. Put the starting value in A2 and the new value in B2. For example, if A2 is 80 and B2 is 100, enter =(B2-A2)/A2 in C2. The difference is 20, and 20 divided by the starting value of 80 is 0.25, so the formatted result is 25%. If the new value were 60 instead, the result would be -25%, indicating a decrease of 25%.
  10. Format percent change and decide how to show decreases. Apply Home > Number > Percent Style (%) to C2. A positive result means an increase, while a negative result means a decrease. You can keep the minus sign to make the direction explicit, or use a separate label such as Change to explain the result. Do not divide by the new value when the question asks for change relative to the starting value.
  11. Choose sensible decimal places. A result such as 48% may be clear with no decimals, while 1 divided by 3 is more informative as 33.33% than 33%. Increase or decrease decimal places with the controls in Home > Number. Avoid showing more precision than the source values justify; extra digits can make a result look more exact than the underlying data.
  12. Verify the result with a quick reverse check. For a share calculation, multiply the displayed percentage by the total and see whether it returns the part, allowing for rounding. For example, 75% of 24 is 18. For a percent-of-amount calculation, check that the result is smaller than the original amount when the rate is between 0% and 100%. These checks help catch swapped cells and mistyped values.

Common Mistakes

  • Multiplying instead of dividing for a share. To find what percentage 18 is of 24, use part divided by total. Multiplying the values answers a different question and produces a much larger number.
  • Multiplying by 100 and then applying percentage format. Excel’s percentage format already displays a decimal such as 0.75 as 75%. If you multiply the decimal by 100 and also apply percentage formatting, Excel displays 7,500% instead.
  • Using the wrong denominator. For percent change, the usual comparison is the difference divided by the starting value. Dividing by the ending value gives a different percentage and does not express the change relative to where you began.
  • Forgetting to fix a repeated total. When filling a formula down, a reference such as C2 changes to C3, C4, and so on. If every row must use the same total, use an absolute reference like $C$2 in the formula.
  • Confusing a displayed percent with the stored value. Excel stores 75% as 0.75. If a cell displays 75% and another formula uses it, Excel uses 0.75 in the calculation, which is normally what you want.
  • Assuming a percentage cannot exceed 100%. A part can be greater than its comparison total, so a result above 100% can be legitimate. Check what the values represent before changing the formula to force a smaller result.

Tips

  • Give input and result columns clear headings. A workbook is easier to audit when readers can tell whether a cell contains a part, a total, a rate, or a percentage result.
  • Keep the formula in the cell and use number formatting to control appearance. Avoid typing a percent sign into a formula result as text, because text values are harder to calculate with and sort consistently.
  • Enter a rate directly as a percentage, such as 20%, or as its decimal equivalent, 0.2. Excel interprets 20% as 0.2 internally. If you type 20 as an ordinary number and then format it as a percentage, it displays as 2,000%.
  • Use absolute references only for values that should stay fixed. A fixed overall total is a good candidate; a row-specific part should remain a relative reference so that it updates as you fill down.
  • For a changing dataset, consider turning the range into an Excel Table with Insert > Table. Tables make headings clearer and can extend formulas and formatting when you add rows. Check that the new rows use the intended total reference.
  • Keep enough decimal places while checking your calculations, even if the final report rounds to a whole percent. A displayed 33% might represent 32.5%, 33.1%, or another nearby value.

Troubleshooting

The result shows 0.75 instead of 75%: The calculation is probably correct. Select the result cell and choose Home > Number > Percent Style (%). If the result changes to 7,500%, check that you have not multiplied the formula by 100 as well.

The formula returns #DIV/0!: The denominator is zero or refers to an empty cell. Check the total or starting-value cell and enter the valid value. If zero is a meaningful possibility, decide what the workbook should show for that case rather than treating it as a normal percentage.

The formula returns #VALUE! or an unexpected result: One or both inputs may be stored as text, include stray spaces, or contain a label instead of a number. Check the source cells, remove unwanted text, and use numeric values. Also verify that the references point to the intended cells.

Copied formulas change the total reference: Edit the first formula so the shared total uses dollar signs, such as $C$2, then fill down again. If only the row should stay fixed while the column changes, or vice versa, use a mixed reference; for a simple vertical list with one total, an absolute reference is usually easiest.

The result looks too large or too small: Confirm whether the formula is meant to find a share, a percentage amount, or a percent change. Check for a reversed numerator and denominator, a rate entered as 20 instead of 20%, or percentage formatting applied to a value already multiplied by 100.

The percent change is negative: A negative result is expected when the new value is below the starting value. Confirm that the starting and new values are in the correct cells. If your report needs to describe the size of the drop without a minus sign, label that convention clearly rather than silently changing the calculation.

Frequently Asked Questions

What is the basic Excel formula for finding a percentage?

Divide the part by the total, then format the result as a percentage. With the part in B2 and the total in C2, enter =B2/C2. If B2 is 18 and C2 is 24, the result displays as 75% after formatting.

Do I need to multiply the formula by 100?

No, not if you are using Excel’s percentage number format. The formula returns a decimal ratio, and Percent Style displays that ratio as a percentage. Multiplying by 100 and applying the format would make the displayed answer 100 times too large.

How do I find what percentage one number is of another?

Use the first number as the part and the second as the total, then divide the part by the total. For instance, 18 out of 24 is 18 divided by 24, or 75%. Confirm that the second number really is the whole you intend to compare against.

How do I calculate a percentage increase in Excel?

Subtract the starting value from the new value, then divide by the starting value. With the starting value in A2 and the new value in B2, enter =(B2-A2)/A2 in C2 and format it as a percentage. A change from 80 to 100 returns 25%.

Can a percentage result be more than 100%?

Yes. If the part is larger than the comparison total, the ratio is greater than 1 and displays above 100%. That may be correct for the question, but it is worth checking the cell roles and the source data before interpreting the result.

How do I show more decimal places in a percentage?

Select the result cell and use Increase Decimal in the Home tab’s Number group until the display has the precision you need. This changes the displayed rounding, not the stored value or the underlying calculation.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.