QueHow

A How-To and wiki Blog

  • Operating System
    • Windows
      • Windows 10
      • Windows 7
    • Linux
  • Software
    • Application Software
    • Microsoft Office
      • Outlook
      • Word
      • PowerPoint
  • Internet
    • Browsers
      • Mozilla Firefox
      • Google Chrome
    • CMS
    • Tips & Tricks
  • Website
    • ecommerce
    • Google
    • Social Networking
    • General Websites
  • Mobile
  • Email
    • Gmail
  • Wiki

How to Subtract in Excel?

By Neha T Leave a Comment

We all are aware of the basic arithmetic operations which are addition, subtraction, multiplication & division. We use subtraction to minus a number from another number. Subtract in excel allow us to minus numbers, cell values, numbers in columns, date, time and many more.

In this section, we will study subtraction in excel with the different type of values as described below:

  1. Subtract Numbers
  2. Subtract Values in Cells
  3. Subtract a Value from Values in Range
  4. Subtract Values in Columns
  5. Subtract Dates
  6. Subtract Time
  7. Subtract Matrix

Steps to Subtract in Excel 2016:

Subtract Numbers

To subtract two numbers, you simply have to write the formula in the cell you want the result to be displayed in. Like in the example below, I have written the formula “=53-26” in the cell A2.

Subtract digit 1

After writing the formula press enter to display the result.

Subtract digit 2

Subtract Values in Cells

If the values to be subtracted are present in the cells. Then the subtraction formula should have the cell reference instead of actual numbers. Like in the example below, the two numbers to be subtracted are present in cell A2 & B2. So, I have mentioned the cell references in my subtraction formula in cell C2.

Subtract values in cells 1

After writing the formula press enter to display the result.

Subtract values in cells 2

Subtract a Value from Values in Range

If you want to subtract a single value from all the values in the range. Write the formula in some cell (in this example B2) and press enter.

Subtract a Value from Values in range- 1

Now drag down formula till you have values in the range to obtain subtraction result from other numbers in the range.

Subtract a Value from Values in range- 2

As you can see we have subtracted number 19 from the values in the cell range A2:A6.

Subtract a Value from Values in range- 3

Other option to obtain the same is to write the number in some cell and then lock the cell in the formula. For example, the number to subtracted is written in cell B2 and while writing the formula we have locked the cell B2.

Subtract a Value from Values in range- 4

To obtain subtraction result from other numbers in the range drag down the formula.

Subtract a Value from Values in range- 6

Subtract Values in Columns

To subtract the values, present in the columns, write the formula of subtraction with the cell references.

Subtract values in Columns- 1

Now drag down the formula till there are values in the range.

Subtract values in Columns- 3

Subtract Dates

To subtract two dates in excel we will discuss three methods. The first method is to simply put the dates in two different cells and supply those cell references in the formula as in the example below.

Subtract date values 1

Note: Be sure that your number format is General.

Subtract date values 2

The second method is to put your dates directly in the formula using DATE function as in the example below.

Subtract date values 3

Keep the Number format as General to obtain a meaningful result.

Subtract date values 4

You can also use the DATEVALUE function in case you have dates in text format.

Subtract date values 5

Subtract Time

We will discuss time subtraction with two methods. With the first method, put your time values in two different cells and supply those references in the subtraction formula as you can see in the image below:

Subtract Time -1

To get the correct result your formula cell must be in the Time Format.

You can directly supply the time value in the formula using the Time function.

Subtract Time 3

Subtract Matrix

If you want to subtract two matrices, simply select the range of cells that has rows and columns equal to the operating matrices.

The formula would be:

=(A2:C4)-(E2:G4)  // press Cntrl+Shift+Enter to convert this into an array  formula.

Subtract matrtix 1

It will display only the first value of the result matrix, to get other values of the result matrix, drag the formula in both the direction (right & down).

Subtract matrtix 2

So, this is all about subtraction in excel. We have covered many scenarios & you can explore to get more. Hope the content is useful. Keep reading.

You Might Also Like:

How to convert text to number in Excel - Featured ImageHow to Convert Text to Number in MS Excel 2016? compare two columns in Excel Feature imageHow to Compare Two Columns to Find Matches & Differences in Excel 2016? Create a named range in Excel feature imageHow to Create Named Range in Excel? Lock Formulas or a Cell in Excel - feature ImageHow to Lock Formulas or Cells in Excel? How to add in Excel-featured imageHow to Add or Sum in MS Excel 2016? count unique values featured imageHow to Count Unique Values in Excel 2016? Change Date Format featured imageHow to Change the Date Format in Excel? Delete Duplicates feature imageHow to Delete Duplicates in Excel 2016?

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Most Viewed

  • How to Install and Use TELNET in Ubuntu
  • How to install Hindi fonts in MS Word
  • How to Change a File Extension in Windows 10?
  • How to create a flipkart account in 3 simple steps
  • How to Change Monitor Refresh Rate in Windows 10?
  • How to install IIS on Windows 10
  • How to Insert Clickable Checkbox in MS Word 2016?
  • How to Set Auto Reply in Outlook 2016?
  • How to Login as Administrator in Windows 10?
  • How to Check RAM Size and System Type in Windows 10?

Recent Additions

  • How to Add Hyperlink to Another Sheet in Excel?
  • How to Add and Remove Watermark in Excel
  • How to use Relative and Absolute Cell Reference in Excel?
  • How to Enable and Disable Scroll Lock in Excel?
  • How to Use INDEX and MATCH Functions in Excel?
  • How to Make Bar Graph in Excel?
  • How to Count Duplicate Values in Excel?
  • How to Wrap Text in Excel?
  • How to Round off Numbers in Excel?
  • How to Create a Bell Curve in Excel?

Related Searches

  • How to Add Font in Microsoft Word
  • How to Install a Language Pack in Windows 7
  • How to Insert a Watermark in MS PowerPoint (PPT)?
  • How to turn off Inactive display in Ubuntu 14.04
  • How to Uninstall Apps in Windows 10?

Copyright © 2023 · QueHow · Contact Us