How to use Excel multiplication function formula

In Excel tables, we often use the Excel formula to count some reports or data, and then we need to use addition, subtraction, multiplication, division, in the previous we have explained in detail the formula for the use of differences. So how do we use formulas to compute the multiplication of some data? How fast and convenient to work out the results? The following small series to teach you step-by-step use of Excel multiplication formula !

Let's start with a simple talk! Let's start with A1*B1=C1, which means that the product result of the first cell multiplied by the second cell is displayed in the third cell.

　　1, a1*b1=c1 Excel multiplication formula

① first, open the table and enter the "=A1*B1" multiplication formula in the C1 cell.

② input is complete, we will find that in the C1 cell will show "0", of course, because there is no data to be multiplied, it will naturally show 0.

③ Now we enter the data to be multiplied in the "A1" and "B1" cells to get the product, as shown in the following figure, I multiply by typing 10 and 50 in the A1 and B1 cells, and the result is displayed in C1, equal to "500".

The above mainly explained two unit cells multiplication method, but in our normal work, may encounter more data multiplication, the following main say multiple cell multiplication formula use, for example: "A1*b1*c1*d1" =e1.

　　2. Multiplication formula of multiple unit cells multiply in Excel

① Enter the multiplication formula "=a1*b1*c1*d1" in the E1 cell.

② then enter the data to be multiplied in A1, B1, C1, and D1, and the result will be displayed in the E1!

Look at the results in the picture is correct! In fact, this method is similar to the above, just a few more numbers.

Because in the work is not only multiplication so simple, occasionally there will be some need to "subtraction" with the operation of the time, then when we encounter this hybrid operation, how should we achieve it? Here depends on your primary school math has not learned. Here let us do a primary school math problem!

　　3, Excel mixed operation multiplication formula, 5 plus 10 minus 3 times 2 is equal to how much?

Hint: Add =+, subtract =-, multiply =*, except =/.

① first of all, we have to understand how this formula is written, "5+10-3*2/3" This is the wrong way to write, the correct writing should be "(5+10-3) *2/3."

② OK, I know the formula, should we come right now enter "= (A1+B1-C1) *d1/e1" in "F1" in Excel.

③ then enter the data to be calculated in A1, B1, C1, D1, E1, and in turn.

OK, some of the above basic multiplication formula has been played, here is a little trick to teach you how to do when there are many lines to calculate?

　　4, copy the formula to each row or column

① first with the mouse to select the "F1" cell, until the mouse into a black cross, the left button down and drag.

② at this point, from the F1 to the following F2, F3, F4 and so on, have copied the "F1" formula, the next time you need to calculate, directly in front of the input data, in the F2, F3, F4 and other cells will automatically display the results of the operation.