In the "Formula" line, write: =B3*E1 and click "OK". After that, the cell will contain not just a number, but the product of the numbers specified in cells B3 and E1. In order for the field to be updated, you need to move the mouse to cell B3, right-click to bring up the context menu and click "Update field".
Perform similar actions for the "Monitor" row. Put B4 in the formula (instead of B3), and the corrected numbers will appear in the required cells:
y.e. 26.18
Name Price, USD Price, RUB Quantity, pcs. Cost, RUB
Computer 567 14,844.06 5 77 220
Monitor 135 3534.3 5 17,671.5
Total 702 18,378.36 10 91 891,5
The same thing needs to be done for the "Cost" column and the "Total" row. After all these manipulations, the indicators in the table will correspond to the changed exchange rate of the conventional unit (taking into account the date).
Thus, the store price list, compiled fantuan database in Word tables, is adjusted using the built-in calculation functions, and basically all actions are performed through the "Formula" dialog box. It is also used to format numbers, work with complex formulas (not only addition, subtraction, multiplication and division are available here). In the "Formula" line, you can insert any combination of numbers, comparison operators and other mathematical operations:
+ Addition
- Subtraction
* Multiplication
/ Division
% Calculating percentages
^ Powers and roots
= Equals
< Less
< = Less than or equal to
> More
> = Greater than or equal to
< > Not equal
In the example above, the "Total" row calculated the sum of the indicators in the specified range of cells (SUM). If necessary, you can add more columns for VAT (the system will also calculate it using the specified formula) and other data required for your business.
At first glance, this does not look very convenient, because as soon as the values in the cells change, you have to update certain fields. But you can do everything faster. For example, if you need to adjust a specific field, you should select it (or the value in it) and click the F9 button. To update all the fields in the table, go to the Edit menu, then click the Select All command and then F9 again. But here's what you need to do to remember to update the document before sending it to print: first, click Tools ® Options ® Print. Here, in the Print tab, find the Mode group and check the box next to Update Fields. Thus, before sending the document to print, the system will update all the field