Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How to Subtract in Excel 2016

Date:2019-8-9 Author:Olivia

In the previous post, you know how to calculate the summation in excel, and what about subtraction? Surely we can use the formula for it, and let’s check it out.

Enter all numbers you want to subtract, here we calculate the value of column A data subtracting column B data and place the difference in column C for each row.

How to Subtract in Excel 2016

First, enter the formula “= A1-B1 ” in the cell “C1”, and press Enter in keyboard, then you get the result of row 1.

How to Subtract in Excel 2016

Next, select “C1” and move the mouse to the bottom right corner of it, a small black cross appears. Left click the mouse and drag to the last row.

How to Subtract in Excel 2016

How to Subtract in Excel 2016

Now you get the method of how to subtract in excel. If there are a large amount of numbers, simply double click the small black cross, and the result is the same.

How to Subtract in Excel 2016

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

1 thought on “How to Subtract in Excel 2016”

  1. ปั๊มไลค์ says:

    Like!! Really appreciate you sharing this blog post.Really thank you! Keep writing.

Leave a Reply

Your email address will not be published. Required fields are marked *