How to Create a Subtraction Formula in Excel – 7 Methods

The sample dataset showcases Employee’s Salaries and Expenses.

Dataset

 


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.

Subtraction Between Two Cells by Generic Formula


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.

Subtraction Formula Between Multiple Cells

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.

Subtraction Formula for Text 

  • Press ENTER to see the result.

Trim and Substitute Functions to create a subtraction formula in Excel

Read More: How to Subtract in Excel Based on Criteria


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.

Subtraction Formula for Percentage 

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


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.

Subtraction Formula Between Two Columns 

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.

Subtraction for a Specific Value Using Cell Reference 

Read More: How to Subtract from Different Sheets in Excel


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.

Subtraction Formula for Dates 

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.

Excel Subtracts the Formula Shortcut


Practice Section

Practice here.

Practice Section


Download Practice Workbook

Download the following practice workbook.


Related Articles


<< Go Back to Subtract in Excel | Calculate in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Fahim Shahriyar Dipto
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

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo