word document form how to calculate the product?Word multiplication calculation method
word is a professional document editing software, mainly used to deal with text, Excel is used to deal with data software. But Word documents can also be inserted into the table, you can also carry out data calculations, the following content to multiply as an example, using Word documents to demonstrate the operation of data calculation. There are free self-study tutorial courses for Word documents, want to learn Word documents partner must look at.
Word document form for multiplication tutorials:
1, open Word, make a 3-line 4 list of cells, enter the following chart;
2, to calculate the amount = unit price × quantity, the cursor is positioned in the amount of the second line column, click the “Form Tools” tab, click inside the “fx formula! “
3, in the formula out of the dialog box, the formula column enter “= B2 * C2”, click “OK”
4, the cursor is positioned in the third line of the amount of columns, the same method in the formula column enter “= B3 * C3”, click “OK”, Word can not be filled with drop-down formulas, only one by one to enter the formula, there is a point to note, if the data have changed, remember to select the form, press “F9 “Update the domain, Word will not automatically update:
The above is a Word document for the multiplication of the form of calculation of the process, after learning that more data can be inserted into the text to illustrate the text, text and data, and better able to show others what you want to express Oh.
word how to calculate multiplication
Open word, click Insert – Form. Input content. Mouse over the first result and click Layout-Formula. Type = PRODUCT(LEFT) in the formula. OK to get the result and copy it to the other totals. Hold F9 to refresh the data, this time all the data is calculated by product.
Formula calculation click “Layout” tab. Select the “Formula” button. Pop-up formula dialog box, for example, in the input box of the formula enter: = B2 * C2 or multiply the corresponding figures, and then you can calculate the results in the corresponding cells.
Preferred point to open a form of word. single right click in the pop-up dialog box click Insert, and then click on the right side of the Insert Columns, that is, in the form of another insert a column. Enter the title multiplication.
First of all, open a word with a table. single right-click in the pop-up dialog box click Insert, click on the right side of the insert column. That is, the completion of the form to insert a column in the far right. Enter the title “multiplication”, the cursor is placed in the location of the data to be entered, and then click on the menu bar in the “Layout”. Then the upper right corner of the formula will appear, click.
WORD form to deal with the table a variety of data formula multiplication how to use?
1, open Word and then insert the table, position the cursor in the total.
2, and then click on the toolbar in the formula.
3, click on the formula, the pop-up formula window, enter the formula for multiplication = PRODUCT (LEFT), and then click OK.
4, after entering the formula for multiply = PRODUCT (LEFT), the total number of the product is obtained.
Use formulas in Word for the product of data
If you want to calculate the sales volume and unit price sales calculations in the word form, you can use the formula function.
Select the cell to insert the formula, in the [Form Tools – Layout] tab click [Formula] button, as shown below.
Open the dialog box, set up the formula, as shown below.
Click the button to the right of the [Numbering Format], in the expanded list, select the number format, as shown below.
You can see the results of the inserted formula calculations, as shown below.
Apply the same method in the dialog box to set the formula and number format, complete the click [OK] button. You can see the effect of the form, as shown below.
word in the form of a two-column product how to calculate
Summary: 1, first open word, click Insert – Forms, select the three columns and two rows. 2, enter the need to calculate the contents of the two columns. 3, the mouse cursor in the form of the first result, click the Form Tools – fx formula. 4, in the public notice, enter = PRODUCT (LEFT), click to confirm. 5, after confirmation, the Forms can be obtained in the two columns of the correct product results.
Demonstration of environmental information: Computer Model: Thinkpad14 System Model: Windows10 Software Version: WPS2019
1, the first to open the word, click on the Insert – Forms, select the three columns of two lines.
2, enter the need to calculate two columns.
3, the mouse cursor in the form of the first result, click on the form of tools – fx formula.
4, enter = PRODUCT (LEFT) in the public notice, click to confirm.
5, after confirmation, the form can get two columns of the correct product results.