How to call the subtraction function in Excel Excel subtraction function application tutorial

  

Excel is a very good office software. You can tabulate some numbers and texts here. Today, Xiaobian brings you the tutorial of Excel subtraction function, I hope to help you!

How to use Excel subtraction function:

For example, we need to calculate the value of column A data of each row minus the value of column B data, and put the difference in column C.

First enter the formula “=A1-B1” (do not quote) in the "C1" cell, then press Enter (ie press “Enter” key)

“C1” cell, move the mouse to the lower right corner of the cell “C1”, a black cross will appear.

At this time, press the left mouse button and drag to "C11” cell

At this point, you will find: the difference between the data of column A of each row minus the data of column B is listed. In the C column of the peer

In addition, Excel can also be used as a calculator, when we want to calculate “ 3.1113-1.765”

can be in the “A1” cell Enter the formula “ = 3.1113-1.765”, then press Enter (that is, press the “Enter” key)

Then “<quo;A1” cells will display “ldld; 3.1113-1.765” The difference.

Copyright © Windows knowledge All Rights Reserved