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.
Search JabSto ::




Custom Search