Current location - Training Enrollment Network - Mathematics courses - What is the formula for batch multiplication of excel tables?
What is the formula for batch multiplication of excel tables?
Excel table batch multiplication calculation formula is as follows:

Computer: MacBook

System: OSX 10.9

Software: Excel20 13

1. Create a new Excel spreadsheet and enter operations in the Excel spreadsheet to demonstrate how to perform batch multiplication in the Excel spreadsheet. As shown below, columns C, D and E are multiplied by 10 in batches.

We know that the way to get the product of two numbers is to multiply the two numbers. Mathematically, the formula is c=axb. Similarly, we also use this method in excel, but the details have changed. Find a cell and enter the value of the multiplicand.

3. After clicking Enter, we can get the product of A 1 and B 1 in the cell C 1, and then put the mouse in the lower right corner of the cell C 1. When the mouse changes to a black solid cross shape, double-click the mouse or hold down the mouse and drop it down to fill in the column value. Select the cell where the multiplicand is located, right-click, and then click Copy.

4. Select the area where data needs to be multiplied in batches.

5. Click to select cell C 1, enter "A 1 and B 1" formulas in the formula editing field, and then click Enter on the keyboard. Right-click, click Paste Special, and then click Multiply.

6. In this way, we can see that the product of column A and column B is calculated by formula, and the corresponding value is placed in column C ... that is, the result is obtained.