How to do subtraction in Excel

Excel four operations.

Taking the range of cells A1 to A5 and cell B6 as examples, A1 to A5 are 1, 2, 3, 4, 5, and B6 is 6, respectively

Addition. sum(a1:a5,b6)

a1+a2+a3+a4+a5+b6

A1 to A5 and B6 are added.

The value is 21 subtraction.

sum(a1:a5)-b6

a1+a2+a3+a4+a5-b6

A1 to A5 add and subtract B6

The value is 9 multiplication.

product(a1:a5,b6)

a1*a2*a3*a4*a5*b6

A1 to A5 and B6 are multiplied.

The value is 720 division.

product(a1:a5)/b6

a1*a2*a3*a4*a5/b6

A1 to A5 are multiplied and b6 is removed

The cells with the value of 20 input formula cannot be the cells that have been referenced in the formula, so as not to form a loop calculation.

** is topped by a row of letters a, b, c, ,..This is the label.

To the left is a vertical column of numbers 1, 2, 3 ,..This is the line number.

The column label plus the row number is the name of the cell, and the cell name is also called the cell address, such as the third row of column A, which is cell A3, the 18th row of column C is cell C18, and the seventh row of column C is cell E7, so that the coordinates are formed one by one, indicating the position of each cell.

C1 input. a1-b1

That is, cell C1 shows the result of A1 minus B1.

Excel**How to use the subtraction formula, this is a simple application of excel, this morning slag Sun Tian will teach you to operate the Fang Liang You method.

1. First of all, open Excel in the computer and enter two numbers to demonstrate, as shown in the figure below.

2. Then enter "=" as shown in the figure below.

3. Then click to select the first number of land chain cells, as shown in the figure below.

4. Then click on the second number cell and press the enter key, as shown in the figure below.

5. The final result will come out, as shown in the figure below.

The subtraction formula in Excel is generally expressed as [=A1-B1] or [sum(A1-B1)].

The steps are as follows:

2. Select C1, enter [=A2-A1], and press Enter after renting carefully, and the C1 cell has shown the result of subtraction at this time.

3. The second method is to select C1 and click the [Insert Function] button.

4. After inserting the function, select the commonly used smile function [sum] in the pop-up window, and then click OK.

5. After selecting the function, a dialog box will pop up for you to select specific parameters, enter [A1-B1] in the first column and click OK, and the subtraction result will be automatically calculated in the C1 cell.

6. If the whole column of C1 is the same calculation method, select the C1 cell, then move the mouse to the lower right corner of the cell, hold down the left mouse button, and then pull down to copy the calculation formula.

The subtraction function in Excel is imsub, but you can also subtract directly with the minus sign "-".

1. Open Excel** on your computer and click Insert Function.

2. Then find imsub in all the letters to Qi Ye.

3. The final formula is imsub (subtracted, subtracted).

4. Get the result without a car, or directly use the symbol, the formula is = subtracted cell - subtracted cell. Missed shouting.

5. Enter to get the result.

Introduction to subtraction functions.

Regarding the excel subtraction function, there is a built-in function: the imsub function. This function is the excel subtraction function.

Its syntax is: imsub(inumber1, inumber2).

The parameter inumber1 is required. Subtracted (complex). inumber2: Required. Subtraction (complex).

As shown in the figure below: the number 1 minus the number 2, the formula of the C2 cell is: =IMSUB(A2,B2), OK, select the C2 cell again, aim the mouse at the lower right corner of the single Shanchayuan grid, when a small black cross appears, at the same time hold down the left mouse button and drag down to fill, Weisen can copy the formula.

Examples of subtraction functions.

As shown in the figure below: A1 cells subtract the last few values one by one, the formula for G1 cells is: =A1-B1-C1-D1-E1-F1, if you need to subtract a lot of cells, such a formula is very cumbersome, you can simplify the formula to:

a1-sum(b1:f1)。

1. Take Excel2010 version as an example, as shown in the figure below, you need to subtract the number of column B from column A;

2. First of all, enter the public bank blocking formula =A1-B1 in cell C1, and press the Enter key to get the calculation result of the first row;

3. Then put the mouse in the lower right corner of the C1 cell, and pull down to fill the calculation formula of the C1 cell, then you can calculate the calculation result of column A minus column B accordingly.

The subtraction function in Excel is purely slippery, which is generally expressed as "=a2-a1" or "let bridge =sum(a2-a1)". Both methods are generally possible, and method 1 is more commonly used. The actual steps are as follows:

1. Open the excel data.

2. Then enter =A1-B1 in cell C1, and press Enter.

3. The result shown in the figure below is obtained.

4. Place the mouse in the lower right corner of cell C1, hold down the left mouse button when the small black cross appears, and drag it to cell C8.

5. You will see the calculation result as shown in the figure below.