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




Custom Search