To find what percentage one cell is of another in Excel, divide the first cell by the second: if the values are in A1 and B1, enter =A1/B1 and format the result as a percentage. If you mean the percentage increase or decrease from an old value to a new one, use a different formula: =(B1-A1)/A1, where A1 is the old value and B1 is the new value.
What “percentage between two cells” can mean
The phrase can describe two related calculations, and choosing the right one matters. A ratio asks how large one value is compared with another, such as what share of a target has been reached. A percentage change asks how much a value rose or fell relative to its starting point. Both calculations divide by a reference value, but their numerators differ.
- Part as a percentage of a total: divide the part by the total. For example, 25 out of 200 is 12.5%.
- Change from an old value to a new value: subtract the old value from the new value, then divide by the old value. A rise from 40 to 50 is 25%.
If you simply type “percentage between” two numbers into a formula, Excel cannot know which meaning you intend. Decide whether one cell is a part and the other is a whole, or whether the cells represent values at two points in time.
Calculate one cell as a percentage of another
Assume A2 contains the part and B2 contains the total. To calculate the part as a share of the total, enter =A2/B2 in C2. If A2 is 25 and B2 is 200, the result is 0.125, which is 12.5% when displayed as a percentage.
The order is important: the part goes on top and the total goes underneath. Reversing the references would calculate the total as a share of the part, which is usually not the question. The denominator should be the number that represents the whole or comparison base.
For instance, if a sales team has completed 36 orders out of a goal of 120, put 36 in A2 and 120 in B2. In C2, with A2 as completed orders and B2 as the goal, enter =A2/B2. The result is 0.3, or 30%. The same structure works for a test score out of a possible score, expenses as a share of a budget, or items completed out of a planned total.
Calculate percentage increase or decrease
For change over time, the reference point is the old value. Assume A2 contains the starting value and B2 contains the later value. Enter =(B2-A2)/A2 in C2. With an old value of 40 and a new value of 50, the calculation is (50 − 40) ÷ 40 = 0.25, so the percentage change is 25%.
A negative result means the value decreased. With an old value of 80 in A2 and a new value of 60 in B2, the formula returns −0.25, or −25%. This expresses a 25% decrease relative to the starting value. Keep the subtraction in the order new minus old; reversing it would change the sign and misstate the direction of change.
When comparing dates in a table, label the columns clearly, such as Old amount, New amount, and % change. Then copy the formula down the results column. Excel adjusts relative references as it fills the formula into later rows: a formula using row 2 references will normally become row 3, row 4, and so on.
Format the result as a percentage
Excel stores percentages as decimal numbers. A result of 0.125 represents 12.5%, and a result of 1 represents 100%. The formula performs the calculation; number formatting controls how Excel displays the result.
- Select the cell or range containing the formula results.
- On the Home tab, in the Number group, choose Percent Style. The displayed value will include a percent sign.
- Use Increase Decimal or Decrease Decimal in the Number group to control how many decimal places appear.
For Microsoft 365 on Windows, these controls are on the Home tab. Excel for Mac has corresponding number-format controls on its Home ribbon; if the ribbon layout differs, select the cells and open the Format Cells dialog to choose Percentage and set decimal places. Formatting changes the display, not the underlying value used in later calculations.
For example, 0.125 may display as 13% when rounded to zero decimal places, or as 12.5% with one decimal place. The underlying result remains 0.125. Add enough decimal places when precision matters, but do not confuse more displayed digits with a more accurate source value.
Do not multiply by 100 when using percentage formatting
A frequent mistake is to multiply the division result by 100 and then apply percentage formatting. If A2 is 25 and B2 is 200, the ratio is 0.125. Percentage formatting displays that value as 12.5%. Multiplying the ratio by 100 first would make the stored result 12.5, which percentage formatting would show as 1,250%.
Usually, enter the division formula without multiplying by 100, then apply Percent Style. Multiplication by 100 is only appropriate if you specifically need the numeric value 12.5 rather than a percentage-formatted value, for example when another system requires a number on a 0-to-100 scale. In that case, make the intended scale clear in the column heading.
Handle zero, blank, and invalid values
A percentage-of-total calculation cannot divide by zero. If the denominator is zero, Excel returns a #DIV/0! error. A blank denominator can also lead to a division error, depending on the calculation. Check that the total or starting value exists and is not zero before interpreting the result.
If a zero denominator should produce a displayed zero in your report, and that fallback is meaningful for your data, use this formula. With the part in A2 and the total in B2, enter =IFERROR(A2/B2,0) in C2. It returns the ratio when the calculation works and 0 if Excel encounters an error. Format C2 as a percentage as usual.
Be cautious with that fallback: a displayed 0% can look like a real measured result even when the total was missing or zero. For analysis, it may be better to leave the error visible or add a separate note explaining why the percentage cannot be calculated. Percentage change from a starting value of zero is likewise undefined; it is not a meaningful infinite increase that Excel can express as an ordinary percentage.
Percentage points are not the same as percent change
When a rate moves from 20% to 25%, it has increased by 5 percentage points. Its relative percentage increase is 25%, because the five-point rise is divided by the original 20%: 5 ÷ 20 = 0.25. These are different ways to describe the same movement.
If A2 contains the old rate and B2 the new rate, with both cells stored as percentages, subtracting the rates gives the change in percentage points. With A2 at 20% and B2 at 25%, enter =B2-A2 in C2. Format C2 as a percentage and it displays 5%—read this as a five-percentage-point difference, not a 5% relative increase.
To express the relative percentage change between those rates instead, use =(B2-A2)/A2. With the same 20% and 25% values in A2 and B2, the calculation is 5% ÷ 20% = 25%. The result is a relative increase of 25%. State which measure you are reporting, especially in dashboards or business reports, because “up 5%” can otherwise be ambiguous.
Use the formula across a table
For a list of records, place the inputs in adjacent columns and the formula in a result column. For example, assume A2:A20 contains each row’s completed amount and B2:B20 contains its corresponding total. In C2, enter =A2/B2, format the result as a percentage, and fill the formula down through C20. Each row will compare its own amount with its own total.
To fill down, select the formula cell and drag the small fill handle at its lower-right corner, or copy the cell and paste into the cells below. On Windows, Ctrl+C and Ctrl+V copy and paste; on Mac, use Command+C and Command+V. Check a few rows after filling to confirm that the references moved as expected and that each numerator is paired with the correct denominator.
If every row should be compared with one fixed total in B1, use an absolute reference for that denominator. With each row’s part in A2 and the fixed total in B1, enter =A2/$B$1 in C2 before filling down. The dollar signs keep the denominator fixed while the numerator changes by row. This is useful for calculating each category’s share of one overall total, but not when each row has its own denominator.
Frequently Asked Questions
What is the formula for percentage between two cells in Excel?
For one cell as a percentage of another, divide the part by the total. If the part is in A1 and the total is in B1, use =A1/B1 and format the result as a percentage. If you mean percentage change, use the old and new values in the percentage-change formula instead.
How do I calculate the percentage difference between two numbers?
People use “percentage difference” to mean different things. For change from an old value to a new value, calculate (new minus old) divided by old. For a simple comparison where neither value is a designated starting point, clarify the convention you need; a symmetric percentage difference often uses the absolute gap divided by the average of the two values.
Why does Excel show 0.25 instead of 25%?
The calculation is likely correct, but the cell is displayed in a general or decimal number format. Select the result and choose Percent Style on the Home tab. A decimal result of 0.25 then displays as 25%.
How do I calculate a percentage increase in Excel?
Put the old value in A2 and the new value in B2. In C2, enter =(B2-A2)/A2, then format C2 as a percentage. A positive result is an increase; a negative result is a decrease. The old value must not be zero.
Can I calculate a percentage if the total is zero?
No ordinary part-over-total percentage is defined when the total is zero, because division by zero is undefined. Check whether the source data is missing or whether a zero total is valid. Avoid replacing the error with 0% unless that display accurately communicates what happened.