Microsoft Office Tutorials and References

In Depth Information

**Create a Formula**

Create a

Formula

You can write a formula to perform a calculation

on data in your worksheet. In Excel, all formulas

begin with an equal sign (=) and contain the cell

references of the cells that contain the relevant

data. For example, the formula for adding the

contents of cells C3 and C4 together is =C3+C4.

You create formulas in the Formula bar; formula

results appear in the cell to which you assign a

formula.

Create a Formula

1
Click in the cell to which you want

to assign a formula.

2
Type
.

●

Excel displays the formula in the

Formula bar and in the active cell.

1

2

3
Click the first cell that you want to

reference in the formula.

Excel inserts the cell reference into

the formula.

●

3

190