Excel table multiplication Function formula

In the Excel table, we often use the Excel formula to count some reports or data, then we need to use addition, subtraction, multiplication, division, in the previous we have explained in detail the Excel summation and the difference formula use method. So how do we use formulas to compute the multiplication of some data? How fast and convenient to work out the results? The following Word federation will teach you step-by-step using the Excel multiplication formula!

Let's start with a simple one! First, we'll teach you the A1*B1=C1, which means that the product result of the first cell multiplied by the second cell appears 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!

See if the results are 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, then when we encounter this hybrid operation, how should we achieve it? Here is to see 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.