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 **profi****t** 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:

- Go to the
**Home**tab. - 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:

**Right, Click**on selected cells and select**Format Cells**.- Select
**Percentage**option. - 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****.**

**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

- Calculate Average Percentage in Excel [Free Template+Calculator]
- Subtract a Percentage in Excel (Easy Way)
- Calculate Percentage Increase between 3 Numbers in Excel [Free Template]
- How to find percentage between two numbers in Excel
- How do you Calculate Percentage Increase or Decrease in Excel
- How to Calculate Cumulative Percentage in Excel
- Excel formula to calculate percentage of grand total (4 Easy Ways)