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.
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.
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.
Now press Enter key, and get your result. See the following snapshot.
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.
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.
Now type a minus sign (-), just next to your selecting value and type SUM after it. After that, you need to select range of cells you are looking to subtract from the first cell. You can select the range of cells by clicking and dragging. See the following image.
If you want to subtract non-neighboring cells too, you can do so easily using Sum Function. Just add a comma (,) to your existing formula and then hold Ctrl button and select all other neighboring cells you want to subtract. Additionally, type static numbers separated by commas. Finish the formula by closing the parentheses and then press enter.
See the example given below:
The result will be o
You might be interested in excel lookup function which is clearly explained at http://dair2.com/excel-lookup-function/