The difference between Microsoft Word and Microsoft Excel is that in the first case the references are absolute. This means that when a cell address is specified in a formula, it (this address) does not depend on where the cell with the formula is located. Excel uses references of the format $A$1, and Word does not use the dollar sign. That is, if in Microsoft Word the cell designation is A1, then in Microsoft Excel it looks like $A$1.
Let's say, for example, that a store's price list contains a table with products and prices, and the data in it needs to be adjusted after the exchange rate of the conventional unit changes. Of course, the cost in rubles and the total amounts will be different.
y.e. 26.75
Name Price, USD Price, RUB Quantity, pcs. Cost, RUB
Computer 567 15 167,25 5 75 836
Monitor 135 3611.25 5 18,056.25
Total 702 18,778.5 10 93 892,25
When using references in formulas, the slovenia email list separators for them are a comma and a colon (this is how the range of actions is designated, i.e. the first and last cells). How can I make a reference to the entire row or column at once in a formula? There are several options. For example, to specify the entire first row of the table in the reference, only the letter or number is written in the range.
If the reference is 1:1, it means that all cells of the first row are automatically included in the formula, and new cells (if any need to be added later) too. If you need to make a reference to the first column, which includes the first three rows of the table, then the range is specified as follows: a1: a3. Thus, only those cells that you have specified will be used in the formula. If you need to include other cells, you will need to change the letters and numbers in the formula as needed.
Let's say, for example, the exchange rate of the conventional unit changed from 26.75 to 26.18 rubles. What steps should be taken to make the necessary recalculations in the table? First, you need to delete the old value in cell E1 at the top and enter a new one instead.
Read also!
"How to Calculate Conversion: 3 Proven Options"
Read more
Then place the cursor in cell C3, go to the “Table” menu and click on the “Formula” command.
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 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 fields in it.
- Board index
- All times are UTC
- Delete cookies
- Contact us