Percentage Difference between Two Percentages Excel (2 Easy Ways)

To get the percentage value in decimal we select the Increase Decimal option

When working with percentages, sometimes we may need to calculate the differences between two percentages. For this purpose, we can get help from MS Excel as it provides various solutions for this type of issue.

Download Practice Workbook

Two Ways to Calculate Percentage Difference between Two Percentages Excel

1. Percentage Difference between Columns in Excel

Let’s assume we have a dataset of products with their profit in two months for showing this process. Now we will calculate their profit difference between two months.

Percentage Difference between Columns in Excel

Step 1: Enter the formula  =C3-B3 in cell D3.

Enter the formula  =C3-B3 in cell D3

Step 2: Copy down the formula up to D7. 

Tip: Here, 1 = 100%, 0.8 = 80%, 0.6 = 60%, 0.4 = 40%, 0.2 = 20%

Copy down the formula up to D7

Step 3: If the result is not in % format, you can convert it into a percentage by following the steps:

  1. Go to the Home tab.
  2. Select the % option under the Number section.

Select the % option under the Number section

Step 4: To get the percentage value in decimal, we select the Increase Decimal option.

To get the percentage value in decimal, we select the Increase Decimal option

Step 5: You can increase or decrease the decimal places by following the steps:

  1. Right, Click on selected cells and select Format Cells.
    Format Cells option
  2. Select Percentage option.
  3. Enter numbers in Decimal places as much as you want the decimal places.
    Enter numbers in Decimal places as much as you want the decimal places.

2. Percentage Difference among the Rows in Excel

Let’s imagine we have a dataset of ABC Company with their two years profits for each product. Now we will calculate the profit differences within these two years.  

Percentage Difference among the Rows in Excel

Step 1: Enter the formula =B5-B4 in B6.

Enter the formula =B5-B4 in B6

Step 2: Copy the formula up to C7.

Copy the formula up to C7

Step 3: If the difference is not in %, convert them into percentages using the % option.

Step 3 If the difference is not in % ,then convert them into percentages % option.

Otherwise, you can follow the process mentioned in the previous method at step 5 for % conversion.

What To Do When Calculating With Negative Percentages

Method 1: Using Absolute (ABS) Function

Sometimes we have negative values at the time of finding differences. This is also applicable for percentage differences. For evaluating the proper differences, we need to make all the values absolute. Let’s consider we have a dataset of some products with their profits. Here we will find out the absolute percentage difference for the example mentioned in the second method.

Using Absolute function

Step 1: Enter the formula =ABS(B4-B3) in C4.

Enter the formula =ABS(B4-B3) in C4.

Step 2:  Copy down the formula up to C7.

Copy down the formula upto C7

Method 2: Using Min-Max function

Let’s assume we have a dataset of products with their two years profit. After calculating the profit differences, we have negative percentages like this:

Using Min Max function

Now we will use the Min-Max function to avoid the negative percentage values. 

Step 1: Enter the formula =MAX(B3:C3)-MIN(B3:C3) in cell D3.

 Enter the formula =MAX(B3C3)-MIN(B3C3) in the cell D3

Step 2: Copy down the formula up to D7.

Copy down the formula up to D7

Read More: Calculate Excel percentage difference between two numbers (using formula)

Percentages Difference Calculator

For practice, here is the percentage difference calculator workbook downloadable file. With this workbook, you can determine the percentage difference of any two percentages. 

Conclusion:

These are the ways to evaluate the percentage difference between two percentages in Excel. Here I have discussed different ways to do this with relevant examples. I hope you all have found it helpful.

Further Readings

Md. Abdullah Al Murad

Md. Abdullah Al Murad

Hello! Welcome to my Profile. Currently, I am working and researching Microsoft Excel, and here I will be posting articles related to this. My last educational degree is BSc, and my program was Computer Science and Engineering from American International University-Bangladesh. I am a Computer Science graduate with a great interest in research and development. Always try to gather knowledge from various sources and try to make innovative solutions.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo