You can either subtract this value from a value in another cell, or you can subtract it from a number that you select.

The steps in this tutorial assume that you have a cell containing a value that you want to subtract. How to Use the Formula for Subtraction Excel 2013 – Subtracting Two Cell Values You can read our Microsoft Excel tutorial on how to add columns if you’ve been looking for an easy way to generate totals for an entire column of values. Specifically, we will focus on subtracting in Excel 2013 by specifying two cell locations that contain numerical values. 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. 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. Learning how to use some of the common mathematical operations, like subtraction, in Excel 2013 with a formula will provide you with a gateway into the world of Excel formulas. if you need to know how to do this, then check out our how to calculate percentage in Excel article. You can use combinations of these functions to generate percentage values. This means it’s possible to add, subtract, divide, and multiply in Excel 2013. You can also compare data and use mathematical functions. Microsoft Excel can do more than just store and sort data.

Press Enter to perform the subtraction.Ĭontinue reading below for more information on how to subtract in Excel, as well as view pictures of these steps.

Enter the first cell value, then a “-” symbol, then the second cell value.

Another example is SUM(A1, A3, A5) which adds the numbers that are contained in cells A1, A3, and A5 (A1, A3, and A5 are arguments).6 Frequently Asked Questions About the Excel Subtraction Formula How to Use the Subtraction Formula in Excel For example, SUM(A1:A5) adds all the numbers in the range of cells A1 through A5. Each argument can be a range, a cell reference, an array, a constant, a formula, or the result from another function.

The SUM function adds all the numbers that you specify as arguments.

To switch between viewing the results and viewing the formulas, press CTRL+` (grave accent) on your keyboard.Or, click the Show Formulas button (on the Formulas tab). In the worksheet, select cell A1, and then press CTRL+V. Subtracts 9000 from 15000 (which equals 6000)Īdds all number in the list, including negative numbers (net result is 16000) Select all of the rows in the table below, then press CTRL-C on your keyboard. Exampleįollow these steps to subtract numbers in different ways: Use the SUM function and convert any numbers that you want to subtract to their negative values. Note: There is no SUBTRACT function in Excel.

Formula to add and subtract in excel