free webpage hit counter

How to Subtract Numbers in Excel

  • You can subtract in Excel by placing the minus sign next to any number you want to subtract.
  • You can add and subtract a bunch of numbers simultaneously using the equal sign or SUM function.
  • You can add and subtract a set of numbers by specifying the range, for example = SUM (A1: A10).

Subtraction in Excel is like subtraction in real life – it’s straightforward. Unlike other common arithmetic functions such as addition, multiplication and division, you have to remember that there is no subtraction in Excel. This means you cannot issue some sort of “subtraction” command. Instead, you subtract with negative numbers. Here are some common ways to do this.

How to Subtract Numbers in Excel

The standard subtraction in Excel is relatively simple. Click on the empty cell, type the equal sign and then enter the numbers you want to subtract. You can enter two or more numbers and add and subtract at the same time. It doesn’t matter which order of numbers you list, as long as you add and subtract, according to the general order of operations. For example, type:

= 100 + 50-10-20

Then press Enter. You get 120 results.

Managing Addition and Subtraction in Microsoft Excel.

To subtract in Excel, use the minus sign as you do arithmetic on paper.

Dave Johnson


If you do the same steps and enter the same:

= 50-10 + 100-20

How to Subtract in Excel Using Cell References

You don’t have to spend numbers in a single directory; You can also set the formula for subtracting values ​​stored in multiple cells. For example, suppose you want to subtract the value of A2 from the value of A1.

Enter some values ​​in A1 and A2. For example, 100 and 25. Then click A3 and press =.

Click on the cell A1 And the A1 label will automatically appear on A3. Press The minus sign () And then click on the cell A2. Press Enter.

You should now see the result of 75 in A3.

Subtraction in Microsoft Excel

In Excel you can subtract one cell from another.

Dave Johnson


How to Subtract Numbers in Excel

You can use the previous technique to subtract cells, but if you have too many cells you want to subtract, there is an easier way – you can simultaneously cover a range of cells.

Suppose you have stored a set of numbers in cells from A1 to A10 and you want to subtract them. Using the SUM function, we can easily calculate the result. In fact, this function can combine the addition and subtraction into a single operation – you have to put the minus sign in each number cell you want to subtract (which means the number looks like a negative number).

1. Enter the numbers you want to use in each directory A1 By the way A10. Note that any numbers you want to subtract must have the minus sign ()

2. Click the cell where you want the final result to appear (for example A11). Model = SUM (. That’s the equal sign, the SUM word and the open parenthesis.

3. Click on the cell A1. While holding down the mouse button, drag the mouse A1 All the way A10. Release the mouse button.

4. Press Enter. Excel automatically closes the enclosure for you and performs the calculation.

Using the SUM Function to Do Addition and Subtraction in Excel

You can add and subtract using the SUM function.

Dave Johnson


Leave a Reply

Your email address will not be published.

Previous post Housing Market: This Utah market has seen the largest price reduction in the US
Next post Bitcoin drops by 2020