# How to Create a Subtraction Formula in Excel – 7 Methods

The sample dataset showcases Employee’s Salaries and Expenses.

### Method 1 – Subtraction Between Two Cells Using Generic Formula

UseÂ  a negative sign and create a subtraction formula for two cells.

Steps:

• Enter the formula in E5.
=C5-D5

It subtracts D5Â from C5.

### Method 2 – Using a Subtraction Formula with Multiple Cells

Use the SUM function and then subtract.

Steps:

• Enter the formula in C9.
=C4-SUM(C5:C8)

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

Read More: How to Subtract Multiple Cells in Excel

### Method 3 – Using a Subtraction Formula for Text

To subtract the first name from the full name, use the TRIM and the SUBSTITUTE functions.

Â Steps:

• Enter the formula in D5.
=TRIM(SUBSTITUTE(B5,C5,””))

Formula Breakdown:

SUBSTITUTE(B5, C5,””)â†’ takes the value of B5 and replaces the value in C5 with B5.

TRIM(SUBSTITUTE(B5, C5,””))â†’ Â takes the result of the SUBSTITUTE function and returns the value.

• Press ENTER to see the result.

### Method 4 – Using a Subtraction Formula for a Percentage

Steps:

• Enter the formula in E5.
=C5-D5

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

### Method 5 – Using a Subtraction Formula Between Two Columns

Steps:

• Enter the formula in E5.
=C5-D5
• Press ENTER to see the result.
• Drag down the Fill Handle to see the result in the rest of the cells.

This is the output.

Read More:Â How to Subtract Two Columns in Excel

### Method 6 –Â  Using a Subtraction formulaÂ  for a Specific Value Using Cell Reference

Steps:

• Enter the formula in D5.
=C5-\$C\$13

\$C\$13 indicates the cell reference. Subtract the value of C13 from C5:C11 in this formula.

### Method 7 – Using a Subtraction Formula for Dates

Use the TODAY function to get the current day and subtract the date from your deadlines.

Steps:

• Enter the formula in E5.
=C5-D5

It shows the remaining days counted from the entered date.

Read More:Â Excel VBA: Subtract One Range from Another

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

Use the SUM function with a negative sign () in the column that we want to subtract.

Enter the formula in E5.

=SUM(C5,-D5)

The SUM function adds the value of these two cells, and the negative sign in the D5 makes all values in column D negative.

Practice here.

## Related Articles

<< Go Back to Subtract in Excel

Get FREE Advanced Excel Exercises with Solutions!
Fahim Shahriyar Dipto

Fahim Shahriyar Dipto is a graduate of Mechanical Engineering at BUET. With over 1.5 years of experience at Exceldemy, he authored 70+ articles on ExcelDemy. He has expertise in designing worksheets at Youâ€™ve Got This Math. Currently, He is a Team Leader at Brainor. Dipto's passion extends to exploring various aspects of Excel. Beyond tech, he enjoys creating engaging kids' worksheets using Illustrator. A dedicated employee and innovative content developer, He incorporates a commitment to academic excellence and... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF