**Microsoft Excel **holds a strong position in the software market as a powerful calculation software. Though there is no exact function to subtract two or more quantities, you can subtract in Excel by using a **negative sign** (**-)**. Subtraction is a very necessary operation in your daily chores. So, in this article, we’re gonna show you **how to create a subtraction formula in Excel**. Let’s get started.

**Table of Contents**hide

## Download Practice Workbook

Download the following practice workbook. It will help you to realize the topic more clearly.

## 7 Simple Ways to Create a Subtraction Formula in Excel

For creating a subtraction formula, we have taken a dataset of *Employee’s*** Salaries** and

**. Now, we want to subtract from these two columns.**

*Expenses*Not to mention, we have used the “** Microsoft 365**” version. You can use any other version at your convenience.

### 1. Subtraction Between Two Cells Using Generic Formula

You can just put a negative sign on your keyboard and create the subtraction formula for two cells. Follow the steps.

**📌**** Steps:**

- First of all, go to cell
**E5**and write up the formula.

**=C5-D5**

It subtracts the **D5** cell value from the **C5** value.

**Read More:** **How to Create an Excel Formula to Subtract (10 Examples)**

### 2. Subtraction Formula Between Multiple Cells

Sometimes, you may want to subtract multiple values from one value. For this, you have to add multiple cells using the **SUM function**. Then subtract as usual. Follow the simple steps.

**📌**** Steps:**

- Firstly, go to cell
**C9**and enter the formula.

**=C4-SUM(C5:C8)**

The **SUM(C5:C8)** syntax adds to your expenses from **C5** to **C8** cells and subtracts them from **C4**.

**Read More:** **How to Create a Formula in Excel for Multiple Cells (9 Methods)**

### 3. Subtraction Formula for Text

This time, we want to subtract the first name from the full name. Take a look at the dataset we have attached below. We have taken the full names of some people, and then we want to extract the first name. We used the **TRIM** and **SUBSTITUTE** functions here. Follow the below steps.

**📌**** Steps:**

- Firstly, move to cell
**D5**and insert the formula.

**=TRIM(SUBSTITUTE(B5,C5,””))**

**Formula Breakdown**:

**SUBSTITUTE(B5, C5,””)→ **Firstly, it takes the value of **B5** and then substitutes the value **C5 **from **B5**.

**TRIM(SUBSTITUTE(B5, C5,””))→ **then the **TRIM** function takes the result of the **SUBSTITUTE** function and returns the value.

Eventually, press **ENTER** and you will get your result like the image below.

**Read More:** **How to Create a Custom Formula in Excel (A Step-by-Step Guideline)**

### 4. Subtraction Formula for Percentage

You can also subtract two cells that contain percentages. The result is also in percentage. Go through the below steps to do it.

**📌**** Steps:**

- Firstly, go to cell
**E5**and write up the formula.

**=C5-D5**

The above formula subtracts the value of **D5** from **C5** and shows the result in percentage.

**Read More:** **How to Create a Formula to Calculate Percentage in Excel**

**Similar Readings**

**How to Create a Formula in Excel to Change Date by 1 Year (3 Methods)****Create a Formula in Excel for Multiple Sheets (4 Methods)****How to Create a Formula in Excel That Will Place the Word Yes (7 Ways)****How to Create a Formula in Excel without Using a Function (6 Approaches)**

### 5. Subtraction Formula Between Two Columns

There is also a formula to subtract two columns. Firstly, you need to apply the formula to two cells and then drag it down to other cells. Follow the below steps.

**📌**** Steps:**

- Initially, go to cell
**E5**and enter the formula.

**=C5-D5**

- Secondly, press
**ENTER**and drag it down for other cells.

Finally, you will get the result shown in the image below.

**Read More:** **How to Apply Formula to Entire Column Without Dragging in Excel**

### 6. Subtraction for a Specific Value Using Cell Reference

We have also shown the way to subtract one specific value from a cell. It is a very simple and easy task to do. We have added the steps below.

**📌**** Steps:**

- Firstly, go to cell
**D5**and input the formula.

**=C5-$C$13**

Here, the **$C$13 **sign indicates the cell reference. We subtract the value of **C13** from **C5:C11** in this formula.

**Read More:** **How to Create a Formula with Structured References in Excel**

### 7. Subtraction Formula for Dates

You can also subtract the two dates and find the remaining days. For doing this, we can use the **TODAY function** for inserting the present day. Then, subtract the date from your deadlines.

**📌**** Steps:**

- Firstly, go to cell
**E5**and enter the formula.

**=C5-D5**

It shows the remaining days counted from your entered date.

**Read More:** **How to Create a Conditional Formula in Excel (5 Easy Ways)**

## Using Shortcut Way to Create a Subtraction Formula in Excel

You can also make a shortcut formula for subtraction in Excel. Here, we have used the **SUM** function but placed a negative sign (**–**) in the column that we want to subtract. So, in this case, a simple formula does your work very easily.

Here, we go to cell **E5** first and write the formula.

**=SUM(C5,-D5)**

Basically, the **SUM **function adds the value of these two cells, but as we enter the negative signs in the **D5** cell, so it takes all the values of the **D** column as negative.

**Read More:** **How to Create a Formula in Excel (5 Ways)**

## Practice Section

We have provided a practice section on each sheet on the right side for your practice. Please do it by yourself.

## Conclusion

That’s all about today’s session. And these are some easy methods to create a subtraction formula in Excel. Please let us know in the comments section if you have any questions or suggestions. For a better understanding, please download the practice sheet. Visit our website, **Exceldemy**, a one-stop Excel solution provider, to find out about diverse kinds of Excel methods. Thanks for your patience in reading this article.