Excel will close the parenthesis for you automatically and perform the calculation. You can subtract cells in Excel simply by putting a minus sign (-) between the cells you want to subtract in the formula bar. While holding the mouse button, drag the mouse from A1 all the way to A10. The basic formula for subtracting two values in Excel is: value1-value2 Now let's explore the different usages for the minus sign in Excel and see the beauty in this simplicity. Once you complete the formula, press Enter key from the keyboard. That is an equal sign, the word SUM, and an open parenthesis.ģ. Note: you can also use cell names such as B1-B2-B3-B4 to perform the subtraction. Click the cell where you want the final result to appear (such as A11).

Remember that any numbers you want to subtract should have a minus sign ( -).Ģ. Enter the numbers you want to use in each cell from A1 through A10. Instead, you may accomplish the task of subtracting numbers or a cells value from the other by using the minus. In fact, this function can combine addition and subtraction into a single operation - you simply need to put a minus sign in the cell of every number you want to subtract (this means the number will look like a negative number).ġ. Using the SUM function, we can calculate the result easily. You can subtract cells in Excel simply by putting a minus sign (-) between the cells you want to subtract in the formula bar. Suppose you have a set of numbers stored in cells A1 through A10, and you want to subtract them. You can use the previous technique to subtract cells, but if you have several cells you want to subtract, there is an easier method - you can subtract a range of cells all at once. How to subtract a range of numbers in Excel

Subtraction excel formula