The percentage difference is usually calculated when you want to know the difference in percentage between two numbers. Microsoft Office Excel is a great tool to help you get started. In this post, we see the method to find the percentage difference between 2 numbers in Excel.
Calculate percentage difference between two numbers in Excel
Percentage change or percentage difference can be applied to any quantity that you measure over time. It is a simple mathematical concept that represents the degree of change over time. The use of simple formulas can help you find the percentage difference between 2 numbers. Here’s how!
1] Enter values
The change in percentage value can be defined as the difference between an original and a new value, divided by the original value.
For example, A company sold $485,000 in 2022 and $598,634 in 2023. Then, what’s the percent change in the two years?
Launch Office Excel. Make two tables eg. ‘2022 Sales’ and ‘2023 Sales’ (Highlight the letters in ‘Bold’, so you don’t mistake them for percentage calculation).
2] Use the formula
Next, click on cell B3 to apply the Percentage format to the cell.
Now, go to the ‘Home’ tab and under ‘Number Format’ select the Percentage button, as shown in the image above.
Note: If you are using the web version of Excel, i.e., Excel for the web, click Home > Number Format > Percentage.
After that, click inside cell B3, divide the second year’s sales ($598,634.00) by the first year ($485,000.00), and then subtract 1. Use the following formula in cell C3. =(B2/A2)-1.
Once done, the change in percentage between the two years will be calculated and displayed instantly. As you can see, the change in percentage between two years was found to be 23%.
Notice the parentheses around (B2/A2). Excel calculates what’s in parentheses first, and then subtracts the 1.
How do you find the percent change between two numbers?
To find the percentage change between two numbers in Excel, you need to use a formula like this: =(B2/A2)-1, where A2 and B2 represent two different cells. However, you need to calculate the percentage differently first. Following that, the aforementioned function would work.
How do you find the percentage difference between two sets of data?
To find the percentage difference between two sets of data in Excel, you can use the aforementioned guide. In other words, it is possible to calculate it by using a formula like this: =(B2/A2)-1. Before that, you need to calculate the percentage and choose a different cell to use this function.
I hope you find this tip useful.
Leave a Reply