Microsoft Office Tutorials and References
In Depth Information
Naming groups of data
7 Select the cell range C5:H5 .
8 On the Formulas tab, in the Defined Names group, click Define Name to open the
New Name dialog box.
9 In the Name field, enter V102LastWeek .
10 Verify that the definition in the Refers to field is =MilesLastWeek!$C$5:$H$5 .
Click OK to create the name and close the New Name dialog box.
In cell A1 , enter the formula =SUM(V102LastWeek) and press Enter . When you do,
the total of all miles for vehicle V102 appears in the cell.
CLEAN UP Close the VehicleMiles workbook, saving your changes if you want to.
Operators and precedence
When you create an Excel formula, you use the built-in functions and arithmetic
operators that define operations such as addition and multiplication. In Excel,
mathematical operators are evaluated in the order shown in the following table.
Negation (e.g., –1)
* and /
Multiplication and Division
+ and –
Addition and Subtraction
Concatenation (adding two strings together)
=, >, <, >=, <=, and <>
Equals, Greater Than, Less Than, Greater Than or Equal To,
Less Than or Equal To, and Not Equal To
If two operators at the same level, such as + and – , occur in the same equation, Excel
evaluates them in left-to-right order. For example, the operations in the formula = 4
+ 8 * 3 – 6 would be evaluated in this order:
8 * 3 , with a result of 24
4 + 24 , with a result of 28
28 – 6 , with a final result of 22