The transposition thinking of Excel subtraction function

Source: Internet
Author: User

First, let's look below.

Computer Tutorials

In the previous table, column A holds the first number, and column B holds the second number. Now, we're going to do this by using a function that implements the first number minus the second number, and the result is in column C.

Only need to use the SUM function can be implemented, the so-called transposition of thinking, but only in front of a positive number plus a minus sign.

The idea derives from mathematical thinking, such as: 1-5=-4, equivalent to 1+ (-5) =-4

The function formula implemented is as follows:

Use the formula in cell C1: =sum (A2,-B2).

The results of other cells, directly down a pull can produce the correct results.

Related Keywords:
Related Article E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth \$300-1200 USD