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
.

11

Click
OK
to create the name and close the
New Name
dialog box.

12

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.

Operator

Description

–

Negation (e.g., –1)

%

Percentage

^

Exponentiation

* 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

1

4 + 24
, with a result of 28

2

28 – 6
, with a final result of 22

3