How to Subtract in Excel 2013 with a Formula


Learning how to subtract in Excel 2013 with a formula will provide you with the gateway into the world of Excel formulas. There are a number of different calculations that Excel is capable of performing, many of which can save you a lot of time if you regularly work with Excel spreadsheets.

This article will provide a brief overview of the Excel subtraction formula, plus some examples of that formula that you can apply to your own spreadsheets. Specifically, we will focus on learning how to subtract in Excel 2013 by specifying two cell locations that contain numerical values.

 

How to Subtract in Excel 2013 – Subtracting Two Cell Values

The steps in this tutorial assume that you have a cell containing a value that you want to subtract. You can either subtract this value from a value in another cell, or you can subtract it from a number that you select.

 

Step 1: Open your spreadsheet in Excel 2013.

 

Step 2: Click inside the cell in which you want to display the result from your subtraction formula. I am going to display my result in cell D2 in the example below. Excel cells are referred to by their column and row location. So cell D2 is in column D and row 2.

click inside the cell where you want the result from your subtraction

 

 

Step 3: Type =B2-C2 into the cell, but replace B2 with the location of the first cell that you will be including in your formula, and replace C2 with the cell location that you are subtracting from your first cell. Press Enter on your keyboard after you type the formula, and the subtraction result will be displayed in the cell.

how to subtract in Excel

 

 

If you want to subtract a cell value from a number that is not in a cell, simply replace one of your cell locations with that number instead. For example, the formula =100-B2 would subtract my value in cell B2 from 100. The important thing to remember when you are learning how to subtract in Excel is that subtracting one value from another requires four basic components.

  1. The “=” symbol at the beginning of the formula. This lets Excel know that it needs to execute a formula.
  2. The first value after the “=”. This can be either a cell location, or a numerical value.
  3. The “-” operator that lets Excel know that you are about to subtract a value from the one that you just identified.
  4. The second value after the “-” operator. As with the first value, this can be either another cell location, or a numerical value.

While we have specifically learned how to subtract in Excel when at least one of the values is a cell location, you can also use the subtraction formula to subtract two numbers. For example, typing “=10-3” will display “7” in the cell, despite the fact that no cell locations were present.

Summary – how to subtract in Excel

  1. Click inside the cell where you want to display the result of the subtraction.
  2. Type =B2-C2, but replace B2 and C2 with the cell locations that you want to subtract.
  3. Press Enter on your keyboard when you are done to display the result in the cell

 

You can learn more about creating formulas in Excel 2013 if you are ready to start unleashing the potential of your current data.

If you need to display the formula instead of the result of the formula, then this article will show you what changes you need to make for that to occur.

birthday t-shirts for boys
vintage t rex t-shirt

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.