# 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 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.

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.

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