How to calculate multiplication in Excel

1 how to calculate multiplication in Excel

Click in the cell where you want the result to appear, and enter =

Enter the cell to be evaluated

For example: Enter in C3 =

And then enter A3*B3

Shun C3 down the lower right corner.

Multiplication--Calculates the product function of all parameters product (), each number in parentheses is separated by commas, and the number of digits must not exceed 30.

As mentioned above, you can edit the formula in cell C1

=product (A1,B1)

Or

=product (A1:B1)

The formula is definitely right, just the way to pull down: first click C3 Select C3 cell, the mouse points to the lower-right corner of the cell C3 (there is a small black spot), when the cursor into a black solid small cross press the left button do not let go, drag down, this operation is called formula Fill, that active cell on the lower right corner of the small black dot is called fill handle , only the action is on the fill handle to fill the formula.

In addition, when the input function is operating, it is important to note that all the delimiters in the Excel function are required to be in the English state, in other words, if you enter a comma under the Chinese input method is invalid.

2 How do I enter the same content in different cells?

Select the cell (you can press CTRL break to select the discontinuous cells), enter content in one cell, do not press ENTER, but press CTRL + ENTER.