By referring to static values Step 1 in formulas, you can calculate extended information. Before you start entering operators and operands, though, it's a good idea to work the formulas out with pen and paper. In the case of our example sales form, you might want a subtotal -- the result of multiplying the product's price by the number of items sold. You'll definitely want a grand total -- the subtotal plus any applicable tax.
Both formulas follow:. To create the table, choose Insert from the Table menu and select Table. In the Insert Table dialog box, specify two columns, five rows, and click OK. Then, enter the appropriate heading text in the left column. With your table ready, it's time to start entering form fields, which allow you to enter data at a specific location. Our example needs form fields to store the three static values and two formulas.
Form fields provide a data type and use formulas that can refer to those values, similar to using a variable. A text form field stores several types of data: text, numbers, symbols, and dates.
It's a little strange to store numeric and date values as text, but don't let the term confuse you. This type of form field doesn't limit the field to storing data strictly as text.
To insert a form field for storing the product price value, you'll need a Number type, which you can insert as follows:. The three form fields store static values -- the product's price, the quantity sold, and any applicable tax.
Now, it's time to add a calculating form field that will subtotal cost. Add the subtotaling form field as follows:. Now you're ready to create a form field that will calculate the grand total.
This one's a little more complex, because you must calculate the tax and add it to the subtotal. To create this calculating field, do the following:.
Available functions. Use bookmarknames or cell references in a formula. RnCn references. A1 references.
Use the Formula dialog box to create your formula. You can type in the Formula box, select a number format from the Number Format list, and paste in functions and bookmarks using the Paste Function and Paste Bookmark lists. In Word, the result of a formula is calculated when it is inserted, and when the document containing the formula opens.
In Outlook, the result of a formula is only calculated when it is inserted and won't be available for the recipient of the email to edit. Select the formulas that you want to update. You can select multiple formulas by holding down the CTRL key while you make selections.
Important: This procedure updates all the field codes in a document, not just formulas. As an example, consider the following procedure for adding numbers by using the SUM function and positional arguments. Important: To avoid an error while summing in a table by using positional arguments, type a zero 0 in any empty cell that will be included in the calculation. Note: Formulas that use positional arguments e. Evaluates whether the argument inside the parentheses is defined.
Returns 1 if the argument has been defined and evaluates without error, 0 if the argument has not been defined or returns an error. Evaluates the first argument. Returns the second argument if the first argument is true; returns the third argument if the first argument is false. Takes two arguments must be numbers or evaluate to numbers.
Returns the remainder after the second argument is divided by the first. If the remainder is 0 zero , returns 0. Takes one argument. Evaluates whether the argument is true. Returns 0 if the argument is true, 1 if the argument is false. Mostly used inside an IF formula. Takes two arguments. If either is true, returns 1. If both are false, returns 0. Takes two arguments first argument must be a number or evaluate to a number; second argument must be an integer or evaluate to an integer.
Rounds the first argument to the number of digits specified by the second argument. If the second argument is greater than zero 0 , first argument is rounded down to the specified number of digits. How to calculate formulas in a Word document Word In some Word documents you need to use formulas, such as summing, subtracting, multiplying, or dividing certain values:.
Failed to send the question. Please try again. How to automatically duplicate information in a Word document A lot of Word documents contain repeated information especially legal documents such as contracts, agreements, invoices, etc. They all contain details of one or two parties that should be repeated two or more times. You can easily create a document with all necessary information in one place and add some special fields for duplicated information:. How to add, subtract, multiply and divide cells in a Word table Most of the people know that Word is for writing texts sometimes containing tables, and Excel is all about tables and calculations for them.
But what if you need to create a Word table with formula. Do you need to create a table in Excel and insert it into Word? No, you don't.
0コメント