Finding differences is a basic and simple task in any mathematical calculation. In Excel, we can do it in very quick and smart ways. It will save time and will show the positive or negative sign after subtracting. So today in this article, I am gonna show **3 useful methods** to **calculate **the** difference between two numbers** positive or negative in Excel.

**Download Practice Workbook**

You can download the free Excel template from here and practice on your own.

**3 Ways to Calculate Positive or Negative Difference Between Two Numbers in Excel**

To explore the methods, weâ€™ll use the following dataset that represents the growth of **Facebook**, **Youtube**, **Twitter**, and **Netflix **for two consecutive months. Weâ€™ll calculate the difference between them using the methods described below.

**1. Manually Calculate Positive or Negative Difference Between Two Numbers**

First, weâ€™ll learn the most basic way to calculate the positive or negative difference between two numbers in Excel. Just type the numbers directly in a cell and subtract.

**Steps:**

- In
**Cell E5**,**type**the following**formula**â€“

`=-6.11%-1.1%`

- Then just
**hit**the**Enter**button to get the output.

As our values are in **percentage formats** and we are directly giving input to the values so weâ€™ll have to keep the** percentage** with the numbers before **subtracting**.

- Later,
**follow**the**same procedure**for the other cells.

*The problem with this method is- if you change any values then they will not be synced in the formula automatically, you will have to change them in the formula manually. So this method is not feasible always. It can be useful just in some particular cases.*

**Read More:** **Excel formula to find difference between two numbers**

**Similar Readings**

**Excel Pivot Table: Difference between Two Columns (3 Cases)****Calculate Time Difference in Numbers (5 Easy Ways)****How to Calculate Significant Difference Between Two Means in Excel****Pivot Table: Percentage Difference between Two Columns**

**2. Use Cell Reference to Find Positive or Negative Differences Between Two Numbers **

Now weâ€™ll calculate the difference by using cell reference instead of using values directly. The benefit of using cell reference is that if you change any number then the formula will be changed automatically according to the values.

**Steps:**

**Write**the following**formula**in**Cell E5**â€“

`=D5-C5`

- Later,
**press**the**Enter**button to get the result.

- Finally,
**drag down**the**Fill Handle icon**to copy the formula for the rest of the cells.

Then soon after you will get the differences like the image below.

**Read More: ****How to Calculate Absolute Difference between Two Numbers in Excel**

**3. Apply Excel SUM Function to Calculate Positive or Negative Difference Between Two Numbers**

Here, weâ€™ll use a function to get the differences. **The SUM function** can be used here for the task because the **SUM **function can give negative output also.

**Steps:**

- In
**Cell E5**,**Write**the following**formula**â€“

`=SUM(D5-C5)`

**Press**the**Enter button**to get the result.

- Finally, use the
**FIll Handle tool**to copy the formula for the other differences.

Hereâ€™s the output after using the **SUM **function.

**Read More: ****How to Find Significant Difference Between Two Numbers in Excel**

**Practice Section**

You will get a practice sheet in the Excel file given above to practice the explained ways.

**Conclusion**

I hope the procedures described above will be good enough to calculate the **difference between** **two numbers positive or negative** in Excel. Feel free to ask any question in the comment section and please give me feedback.

## Related Readings

**Difference Between Two Dates in Months in Excel (4 Suitable Examples)****How to Calculate Difference Between Two Times in Excel (8 Methods)****How to Calculate Time Difference in Minutes in Excel (3 Easy Methods)****How to Calculate Time Difference in Excel Between Two Dates (7 Ways)****Calculate Difference Between Two Rows in Pivot Table (with Easy Steps)****How to Calculate Difference Between Two Dates in Days in Excel**

not really relevant to 2 totally differing numbers that are NOT %’s.

Hello CJ, thanks for your feedback.

Just skip the percentage if it doesn’t get relevant, the formula and procedures are the same.