Microsoft Office Tutorials and References

In Depth Information

**Create a Formula**

11

CHAPTER

EXCEL

Working with Formulas and Functions

4
Type an operator for the formula.

5
Click the next cell that you want to

include in the formula.

C
Excel inserts the cell reference into

the formula.

6
Repeat Steps
and
until all the
5

necessary cells and operators have

been added.

7
Press .

D
You can also click
Enter
( ) on the

Formula bar to accept the formula.

E
You can click
Cancel
(

) to cancel

the formula.

F
The result of the formula appears in

the cell.

G
The formula appears in the Formula

bar; you can view it by clicking the

cell containing the formula.

Note:
If you change a value in a cell

referenced in your formula, Excel

automatically updates the formula result

to reflect the change.

TIPS

How do I edit a formula?

To edit a formula, click in the cell containing the

formula and make any corrections in the Formula

bar. Alternatively, double-click in the cell to make

edits to the formula from within the cell. When

finished, press

How do I reference cells in other worksheets?

To reference a cell in another worksheet, specify

the worksheet name followed by an exclamation

mark and then the cell address (for example,

Sheet2!D12 or Sales!D12). If the worksheet name

includes spaces, enclose the sheet name in single

quote marks, as in ‘Sales Totals’!D12.

or click
Enter
(

) on the

Formula bar.

197