How to multiply the data in WPS

1. First of all, in the current WPS** file, select a cell in a certain row.

2. After the cell selection is completed, then =<> on the input to input

3. Enter =c6*d6<> in the cell input box

4. After the formula is entered in the current cell, click on the blank space. You can complete the calculation of one row.

5. Then after selecting the cell, click in the lower right corner and drag it down.

6. In this way, all the formatting is completed, and the calculation of multiplying the data of all rows is completed.

1. Click to enter the ** interface.

2. Use the function to calculate (that is, the fx above).

3. Enter two numbers in A1 and B1.

4. Hover over C1, because the result of the calculation will appear in C1.

5. Enter "=" in FX first

6. Hold down the Ctrl key and click A1, then enter the * sign, and click B1 <> in the same way

7. Enter the result.

8. Next is a set of data.

9. Click the mouse on the first result, place the mouse in the lower right corner (it will become a cross), and pull down.

10. Let go and finish.

It should be easy to get it, first determine the position of your product place, select this position, and click the function button; Select the multiplier, follow the function with an asterisk, then select the multiplier, and finally press enter.

If you can't see the cell area clearly, directly enter =b2*c2 and pull down to where you need it and try it.

Here's how to multiply two values by WPS Word**:

Scenario 1: The two numeric cells to be multiplied are adjacent to the result cells, as follows:

Position the cursor in the result cell, click "**Tools" "FX Formula", and enter =product(left) in the pop-up formula dialog box

product is the product function, and left represents the calculation area (left is calculated to the left of the current cell, right is calculated to the right of the current cell, below is calculated to the bottom of the current cell, and above is calculated to the top of the current cell).

Scenario 2: The two numeric cells to be multiplied are not adjacent to the result cell, and the method is as follows:

Position the cursor in the result cell, click "**Tools" "FX Formula", and enter =a1*c1 in the pop-up formula dialog box

A1 and C1 refer to two numeric cell names that need to be multiplied (WPS Word and WPS Excel have the same naming of cell names, with column labels and row numbers indicating cell names), and * refers to the arithmetic operator.

WPSOFFICE is an office software suite independently developed by Beijing Kingsoft Office Software, which can realize the most commonly used text, presentation, PDF reading and other functions of office software. It has the advantages of low memory usage, fast running speed, multiple cloud functions, strong plug-in platform support, and free storage space and document templates. Support pdf (..)

pdf) file reading and output, with full compatibility with retrofitting! WPS is also the most commonly used software tool in the workplace, and it is especially necessary to learn and master it! Therefore, I will provide you with the ** course learning of WPSOFFICE software, and you can start learning if you are interested in it

First of all, open Excel**, we know that the finished product quantity is equal to the raw material quantity and the yield rate:

Enter = in cell d2 and click b2, then enter * and click c2:

This requires the product of the b2he2 cells. We move the mouse to the lower right corner of cell D2, when the cursor changes to a black cross, drag the left mouse button to fill all the cells that need to accumulate:

Release the mouse and all values are calculated.

The above is the article in this issue about "How to calculate data in WPS**?" How do you multiply data? I hope you have learned!

Finally, if you have zero knowledge or want to advance the operation of WPS, you can learn the course: WPSOFFICE zero-based beginner to proficient in a full set of tutorials, I believe it is also your choice

Here's how:

1. Enter =A1*B1 in box C1, and then click Enter to get the product of A1 and B1.

2. When you want to calculate the product of column A and column B, do this: place the mouse in the lower right corner of C1, and act as the mouse.

When it turns into a cross, press and hold the drop-down.

3. The shape of the pull-down is as shown below.

4. Release the mouse, the product of column A and column B can be calculated, which is the same operation in WPS Excel and Office Excel.

If you press =a1*b1 to click and tick, the product will not be displayed.

Suppose that columns A and B are multiplied and placed in column C. Enter the formula =A1*B1 in C1, press Enter to enter the formula, click C1 again, move the mouse to the black cross in the lower right corner, click and drag down to copy the formula to the following cells.

If you have any questions, please click on my avatar to ask questions. Have a great day!