'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Calculate Percentage Difference Between Two Numbers in Excel
Question details
The user needs to find the percentage increase or decrease between an original number and a new number.
- Product
- Excel
- Device & OS
- not provided
- Scenario
- Comparing two values to determine the percentage change, such as tracking sales growth, monthly expenses, or price drops.
- Observed behavior
- The user needs a reliable formula to divide the difference between two cells by the original value and format the resulting decimal as a percentage.
Ensure your original value (the baseline) is not zero, as dividing by zero will return a #DIV/0! error in Excel. Identify exactly which cell holds your old value and which holds the new value.
Use the Standard Subtraction and Division Formula
Calculate the exact difference first, then divide by the original number to find the percentage change.
This is the most common and intuitive way to find a percentage difference. It first subtracts the old value from the new value to find the absolute change, then divides that difference by the old value to get the relative change.
Click on an empty cell where you want the percentage difference result to appear.
Type the formula =(B1-A1)/A1 (assuming A1 is your original number and B1 is your new number) and press the Enter key.
Select the result cell again, navigate to the 'Home' tab on the ribbon, and click the '%' (Percentage Style) button in the Number group to convert the decimal output into a readable percentage.
Use the Direct Division Formula
A shorter alternative that divides the new value by the original value and subtracts 1.
Calculate Percentage Differences Easily with WPS Spreadsheet
WPS Office provides a highly compatible and free spreadsheet tool that supports all standard Excel formulas, including percentage calculations. You can seamlessly open your Excel files and perform data analysis without any learning curve.
- 1. Open your dataset: Launch WPS Spreadsheet and open the file containing the numbers you want to compare.
- 2. Input the calculation formula: Click on the target blank cell and type =(B1-A1)/A1.
- 3. Format the result: Press Enter, then click the '%' icon on the Home tab to instantly format the decimal as a percentage.
- 4. Apply to multiple rows: Click and drag the small square (fill handle) at the bottom right corner of the cell downwards to apply the formula to the rest of your data column.
Frequently Asked Questions
Why am I getting a #DIV/0! error when calculating percentage difference?
This error occurs if your original value (e.g., cell A1) is zero or empty, because mathematically you cannot divide by zero. To fix this, you can use the IFERROR function, like =IFERROR((B1-A1)/A1, 0), which will display a 0 or blank instead of an error.
How do I calculate a percentage decrease?
You do not need a special formula for a decrease. The same formulas =(B1-A1)/A1 or =B1/A1-1 automatically calculate decreases. If the new value is smaller than the original value, the result will be a negative percentage (e.g., -15%), indicating a decrease.
Can I apply this percentage formula to an entire column at once?
Yes. After entering the formula in the first cell and formatting it as a percentage, select that cell. Hover your mouse over the bottom-right corner until the cursor turns into a black plus sign (+), then click and drag down to automatically fill the formula for the remaining rows.
