How to How to Calculate Percentage Increase Between Two Numbers in Excel in Excel - Practical Guide

Learn to calculate percentage increase between two numbers using Excel formulas. This essential skill helps you analyze growth metrics, price changes, and performance improvements. You'll master the percentage increase formula and apply it to real-world datasets, enabling quick financial and statistical analysis without manual calculations.

Why This Matters

Percentage increase calculations are critical for business analysis, financial reporting, and data-driven decision-making. Automating this in Excel saves time and eliminates manual calculation errors.

Prerequisites

•Basic understanding of Excel spreadsheet structure and cell references
•Familiarity with simple arithmetic operations and formula entry

Step-by-Step Instructions

Enter your original and new values

Input your starting value in cell A1 and ending value in cell B1. For example, enter 100 in A1 (original price) and 150 in B1 (new price).

Click on the result cell

Select cell C1 where you want the percentage increase result to appear. This is where your formula will be entered.

Enter the percentage increase formula

Type the formula: =(B1-A1)/A1*100 and press Enter. This calculates (New Value - Original Value) / Original Value × 100.

Format the result as percentage (optional)

Right-click cell C1 > Format Cells > Number tab > select Percentage > OK. If using the formula above, set decimal places to 2 for clarity.

Copy the formula for multiple rows

Click C1, copy (Ctrl+C), select the range below, and paste (Ctrl+V) to calculate percentage increase for all data rows automatically.

Alternative Methods

Using the decimal format method

Use =(B1-A1)/A1 without multiplying by 100, then format as percentage. Excel automatically displays the result as a percentage.

Using the ROUND function for precision

Combine with ROUND: =ROUND((B1-A1)/A1*100,2) to limit results to 2 decimal places and prevent rounding errors.

Tips & Tricks

✓Always place the original value in the denominator to ensure accurate percentage calculations.
✓Use absolute references ($A$1) if you need to copy formulas while keeping the original value fixed.
✓For negative percentage increases (decreases), the formula still works—the result will display a negative percentage.

Pro Tips

★Create a custom number format [0.00"%"] to display percentages with consistent formatting across large datasets.
★Use conditional formatting (Home > Conditional Formatting > Color Scales) to visually highlight high and low percentage increases.
★Combine with IF statements to flag significant changes: =IF((B1-A1)/A1>0.1,"High Growth","Normal").

Troubleshooting

Formula returns #DIV/0! error

This occurs when the original value (denominator) is zero. Check that cell A1 contains a non-zero number, or use error handling: =IFERROR((B1-A1)/A1*100,0).

Result displays as a decimal (0.50) instead of percentage (50%)

Right-click the cell > Format Cells > Number tab > select Percentage category > set decimal places > OK. Alternatively, multiply by 100 in the formula.

Percentage values appear incorrect or unexpected

Verify you're using the correct formula: =(New-Original)/Original*100. Ensure Original and New values are in the correct cells and formatted as numbers, not text.

Related Excel Formulas

ROUND IFERROR IF ABS AVERAGE PERCENTILE

Frequently Asked Questions

Can I calculate percentage decrease using the same formula?

Yes, the formula works for both increases and decreases. If the new value is smaller than the original, the result will be negative, indicating a percentage decrease. For example, if original is 100 and new is 80, the result is -20%.

Should I multiply by 100 in the formula or use percentage formatting?

Both methods work. Multiplying by 100 gives explicit percentage values (50), while percentage formatting displays decimals as percentages (0.5 becomes 50%). Choose based on your preference and dataset requirements.

How do I handle negative original values?

The formula still calculates mathematically, but the result may be misleading in business contexts. For example, comparing -100 to 100 yields a 200% increase, which might not reflect true business growth. Consider your data context carefully.

Can I calculate compound percentage increases?

Yes, use the formula =(B1-A1)/A1*100 for each period separately, or for multiple periods: =((Final/Initial)^(1/n)-1)*100, where n is the number of periods.