Microsoft Office Tutorials and References

In Depth Information

**Building a formula**

There are six operators you can use to construct comparison formulas, as shown in the

following table.

OPERATOR

NAME

EXAMPLE

RESULT

=

Equal to

= 10 = 5

0

<

Less than

= 10 < 5

0

< =

Less than or equal to

= 10 <= 5

0

>

Greater than

= 10 > 5

1

> =

Greater than or equal to

= 10 >= 5

1

< >

Not equal to

= 10 < > 5

1

Operator precedence

The order in which Excel performs the calculations is important. Excel evaluates a formula

according to a predei ned order of precedence, which is determined by the formula

operators. For the formula =3+5^2, Excel performs the exponentiation before the addition

because of the operator precedence, resulting in 28. The following table shows how Excel

orders operations.

OPERATION

PRECEDENCE

Parentheses ( )

1st

Negation (-)

2nd

Percentage (%)

3rd

Exponentiation (^)

4th

Multiplication (*) and division (/)

5th

Addition (+) and subtraction (-)

6th

Comparison < = >

7th

Building a formula

You can add a formula to a worksheet cell by starting the formula with an equal sign (=) and

then typing the operands and operators. When you add a formula to a cell, Excel displays the

formula result in the cell, not the actual formula.

In this exercise, you will open a document and save it. Youâ€™ll then build a formula.

To open the document you need for this lesson:

1

Launch Excel. Excel displays a blank page.

2

Choose File > Open and navigate to the Excel05lessons folder.

3

Click excel0501 and then click Open.

4

Select File > Save As.

5

In the Save As text i eld, type
excel0501_done
and then click Save.