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 values or cell references to the cells that contain

the relevant values. 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.

Note that, in addition to referring to cells in the current worksheet, you can also build formulas that

refer to cells in other worksheets.

Create a Formula

1
Click the cell where you want

to place a formula.

2
Type
.

A
Excel displays the formula in

the Formula bar and in the

active cell.

3
Click the first cell that you

want to include in the

formula.

B
Excel inserts the cell

reference into the formula.

196