How to Subtract in Excel 2013

Excel has numerous formulas that allow users to perform different calculations and save their time. Subtract is one of the major and most used formulas in Excel, which helps you to subtract numbers in a range and cell.

In our today’s tutorial, we will introduce to you a brief overview of the Excel subtraction, and make you learn how to use this formula in Microsoft Excel 2013.

So let’s understand this amazing formula with some simple examples.

Like, previous versions of Microsoft Office, Excel 2013 does not support a SUBTRACT function as you might expect. However, in Office 2013, you get two options for subtracting cells from one another. Either you can use a mathematical equation or SUM function to apply subtraction formula. Whatever you feel you are more comfortable with.

1st Method – Subtraction Equation

Whenever we think to use the simplest way to subtract in Excel, equation is the first method that comes to mind.

Step 1

First, write two values in two different cells. Now type the equal sign (=) in the empty cell where you want to display the result. Now click on the cell containing a value from which you want to subtract. As soon as you click on the cell, its location will be displayed in your equation. See the snapshot given below.

How to Subtract in Excel 2013

Step 2

Next step is to add minus sign (-) to your equation. Now click on the cell containing the value that you want to subtract. Excel will automatically add its location to the equation as shown in the image given below.

How to Subtract in Excel 2013

Step 3

Now press Enter key, and get your result. See the following snapshot.

 How to Subtract in Excel 2013

2nd Method- Sum Function

Along with adding numbers, Sum Function can also be used for subtracting numbers. The function works with both ranges and individuals cell. Thus using sum function you can deal with many cells at once.

Step 1

Similar to equation method, you need to type the equal sign (=) in a blank cell. Then, click the cell you are looking to subtract from.

Step 2

Now type a minus sign (-), …