Microsoft Office Tutorials and References
In Depth Information
Build a Formula
Build a
Formula
You can add a formula to a worksheet cell using a
technique similar to adding data to a cell. To ensure
that Excel treats the text as a formula, be sure to
begin with an equal sign (=) and then type your
operands and operators.
When you add a formula to a cell, Excel displays the
formula result in the cell, not the actual formula. For
example, if you add the formula =C3+C4 to a cell,
that cell displays the sum of the values in cells C3
and C4. To see the formula, click the cell and
examine the formula bar.
Build a Formula
1 Click in the cell in which you
want to build the formula.
2 Type .
A Your typing also appears in the
formula bar.
Note: You can also type the
formula into the formula bar.
3 Type or click an operand. For
example, to reference a cell in
your formula, click in the cell.
B Excel inserts the address of the
clicked cell into the formula.
Search JabSto ::




Custom Search