EDUCBA

EDUCBA

MENUMENU
  • Blog
  • All Courses
  • All in One Bundle
  • Login
Home Excel Excel Resources Excel Tips Subtraction in Excel

Subtraction in Excel

Madhuri Thakur
Article byMadhuri Thakur

Updated August 16, 2023

Subtraction in Excel

Introduction to Subtraction in Excel

In this article, we will learn about subtraction in Excel. Subtraction means you are taking something away from a group. As per mathematics, there are three parts to the subtraction equation.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

e.g., In problem 6 – 4 = 2, the number 6 is called the minuend, the number 4 is called the subtrahend, and the number 2 is the difference.

Currently, there is no specific or inbuilt universal Subtraction function or formula in Excel; to perform a subtraction between two numbers, you have to use the dash (-) or minus sign symbol, which is a subtraction sign or arithmetic operator to subtract between two numbers.

The below mentioned arithmetic operators are used to perform the calculation in Excel.

Arithmetic Operators  Mathematics Excel
Addition + +
Subtraction –  –
Multiplication X  *
Division /  /
Equals = =

With the help of the dash (-) symbol, you can quickly subtract between numbers, cells, entire rows, and columns.

Subtraction

Subtraction is the opposite of the addition process. It is an operation performed on a pair of numbers to obtain or derive a difference between two numbers.

The SUM function is also helpful in Subtraction, where it subtracts all the numbers given as a range of values in arguments and returns the desired output.

How to do Subtraction Between Numbers and other Values in Excel

Let’s check out how the SUBTRACT works in Excel. You can create a formula to subtract two or more numbers in Excel.

The criteria for creating a formula for subtraction in Excel is

  • It should always begin with an equal sign (=).
  • The formula is entered in a cell where you want the result to appear.
  • The subtraction sign in Excel is the dash (-), an arithmetic operator.
  • Subtraction can be done by entering the numbers which you want to subtract directly into a formula, e.g., =6-4 results, or returns the value 2

Subtraction Examples1

It can also be done by entering or using cell references or addresses in the formula.

e.g., =B16-C16, in the below-mentioned example returns the value 4

Sub

An advantage of using a cell reference

  • When cell references are used instead of the actual data or number in a formula, later, the cell reference data in the formula can be replaced or changed to get the desired output. In this scenario, you do not have to write a complete formula again. Instead, the results of the formula update automatically when the cell reference or data changes.

How to Use the Subtraction in Excel?

Subtraction is very easy to use. Let us now see how to use Subtraction in Excel with the help of some examples.

You can download this Subtraction Excel Template here – Subtraction Excel Template

Example #1 – Subtraction of numbers in a cell

In the below-mentioned example, I have a number in a cell “B8” & “C8”. So, I need to create Subtract formula in a cell “D8” to derive a difference between two numbers.

between two numbers

Type the equal sign “=” in cell D8 to begin the formula where you want to get the equation’s result.

begin the formula

You can enter the numbers directly which you want to subtract directly into a formula, i.e., =6-4

The subtraction sign in Excel is the dash (-) which is an arithmetic operator used after entering the number 6 and entering another number after the dash (-), i.e., 4

after entering number

Press the Enter key to complete the formula. For example, answer 2 appears in cell D8.

Subtraction complete the formula

Example #2 – Subtraction with a cell reference or address in the formula

In the below-mentioned example, I have a number in cells “B16” & “C16”. I need to create Subtract formula in cell “D16” to derive the difference between two cell references or numbers

two cell references

Type the equal sign “=” in cell D16 to begin the formula, where you want to get the equation’s result

equation's result

You can enter the cell references directly, which you want to subtract directly into the formula, i.e., =B16-C16

The subtraction sign in Excel is the dash (-) which is an arithmetic operator used after entering the first cell reference, “B16,” and entering another cell reference after the dash (-), i.e., “C16.”

 first cell reference

Press the Enter key to complete the formula. For example, answer 4 appears in cell D16.

 answer 4 appears

Example #3 – Subtraction with the help of the Sum function

If there are huge numbers in a dataset, it will be difficult to do subtraction with a specific number. The SUM function will help out to shorten your formula.

In the below-mentioned example, I have a set of numbers in a range of cell “I6” TO “I10”, and I want to do subtraction with cell reference “K6”, i.e., 60.

 cell reference

I need to create a subtract formula and some function in cell “K9” to derive a difference between cell range references & give a specific number.

Subtraction Example 3-2

Type the equal sign “=” in cell K9 to begin the formula where you want to get the equation’s result.

get equation's result

An initial step is to add a set of numbers in a range of cell “I6” TO “I10” by using a function where you can directly enter the cell range references in the SUM function argument.

Subtraction Example 3-4

After entering the sum function argument, add the Subtraction sign, i.e., dash (-), which is an arithmetic operator used after entering the Sum function, and enter another cell reference after a dash (-), i.e., “K6”, which you want to subtract.

Subtraction Example 3-5

=SUM(I6:I10)-K6 will return the value 182, i.e., It is the difference value between numbers in a range of cell & 60

difference value between numbers

Example #4 – Subtraction between two dates

It is very easy to subtract dates in Excel. We just have to enter an End date and Start date in individual cells and subtract one cell from the other, i.e., End date with a Start date, to get the desired output.

i.e. =End_date-Start_date

You can also supply dates directly into the formula or with the help of the DATE or DATEVALUE function.

E.G.

=DATE (2018,12,20)-DATE (2018,12,01)

=DATEVALUE (“12/20/2018”)-DATEVALUE (“12/01/2018”)

DATEVALUE

Apply Subtraction Method, i.e., H16-I16

Subtraction Method

It will return 19 as a Result

Subtraction Example 4-3

Similarly, we find the other value

Subtraction Example 4-4

Note: The formula should use the end date before the start date. Otherwise, it will return a negative value.

Things to Remember

Excel has an order of Operations (when Using Parenthesis () & mathematical operations)

i.e., If anything, the inside of the parenthesis is calculated first in the formula. Later multiplication and division are performed next and at last, Addition and subtraction.

With the help of the subtract function, you can also find the time differences between two-time values using the =End time – Start time formula. Select Time custom format “h:mm” from the Format Cells options for this.

Subtraction Example

Subtract formula also helps out to subtract percentage between two percentage values in Excel, e.g., =100%-60% returns the value 40%

Subtraction Example 1

Recommended Articles

This has been a guide to Subtraction in Excel. Here we discuss the Subtraction Formula and how to use Subtraction in Excel, along with practical examples and a downloadable Excel template. You can also go through our other suggested articles –

  1. Excel Subtract Time
  2. Subtract the Date In Excel
  3. Write the Formula in Excel
  4. Divide Cells in Excel
MICROSOFT POWER BI Course Bundle - 8 Courses in 1
34+ Hours of HD Videos
8 Courses
Verifiable Certificate of Completion
Lifetime Access
4.5
MS Excel & VBA for Data Science Course Bundle - 24 Courses in 1 | 10 Mock Tests
87+ Hours of HD Videos
24 Courses
10 Mock Tests & Quizzes
Verifiable Certificate of Completion
Lifetime Access
4.5
All-in-One Financial Analyst Masters Training Program Bundle - 550+ Courses | 300+ Mock Tests | 2000+ Hours | Lifetime |
2000+ Hours of HD Videos
43 Learning Paths
550+ Courses
Verifiable Certificate of Completion
Lifetime Access
4.9
All-in-One Data Science Bundle - 400+ Courses | 550+ Mock Tests | 2000+ Hours | Lifetime |
2000+ Hour of HD Videos
80 Learning Paths
400+ Courses
Verifiable Certificate of Completion
Lifetime Access
4.7
Primary Sidebar
Popular Course in this category
MS Excel Course Bundle - 36 Courses in 1 | 13 Mock Tests
 137+ Hours of HD Videos
36 Courses
13 Mock Tests & Quizzes
  Verifiable Certificate of Completion
  Lifetime Access
4.9
Price

View Course
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

Download Subtraction Excel Template

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download Subtraction Excel Template

EDUCBA

डाउनलोड Subtraction Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more