Faculties and centres
Excel uses three operators for working with ranges: colon, space and a semicolon. To see how each of them, use the following example:
Two items: specifies a range that goes from the first cell to the second following a rectangle. In our example, the range C2: D4 includes cells C2, C3, C4, D2, D3 and D4. For example, the result of applying the formula =SUMA(C2:D4) will 105000.
Area: Gets the value of the intersection. Example: If in cell A6 enter = C2: C4 B3: D3 will result in 30,000, which is the amount that intersects the range C2: C4 with the range B3: D3.
semicolon: Specify the union of two ranges. If you write to A6 = SUM (C2: C4, B3: D3), which is actually adding C2, C3, C4, B3, C3 (for the second time) and D3. The result will be 258,000.
|2. With Names|
The real value of the intersection of ranges is shown when using names. For example, if we select the table and then choose from the menu Insert, Name, Create, clicking OK in the Create Names dialog box, Excel creates the following names to automatically:
With these names you can create formulas easily readable. Some examples:
Space: =Incen White obtained a semicolon 30,000: =Sum(Incen;White) 258,000 is obtained.
We have the data in the table above, which are the costs of travel from Alicante to Gerona from a prestigious professor.
1. Determining how much was spent in Valencia, Tarragona and Girona.
2. Determining how much was spent on food.
3. Determining how much was spent on food and Tarragona (care to repeating the error amounts to add).
4. Automatically create names for all ranks involved in the above formulas.
5. Automatically replaced by their names ranks.