# Percentage Difference between Two Percentages Excel (2 Easy Ways) 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.

## 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. Step 1: 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% 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. Step 4: 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. 2. Select Percentage option.
3. 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. Step 1: Enter the formula` =B5-B4` in B6. Step 2: Copy the formula up to C7. Step 3: If the difference is not in %, convert them into percentages using the % 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. Step 1: Enter the formula `=ABS(B4-B3)` in C4. Step 2:  Copy down the formula up to 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: 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. Step 2: Copy down the formula up to D7. ## 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.  