Microsoft Office Tutorials and References
In Depth Information
Creating simple cell formulas
Creating simple cell formulas
Building calculations in Excel is pretty straightforward. If you
want to find the sum of the values in two cells, you just type an
equal sign (=), the reference of the first cell, a plus sign (+), and
the reference of the second cell. The formula that you enter
appears on the formula bar, where you can examine and edit it.
Build a formula
1 Click the cell in which you want to enter a formula.
2 Type = .
3 Type the expression representing the calculation that you want to
perform.
4 Press Enter.
3
Edit a formula
1 Click the cell that you want to edit.
2 Select the part of the formula that you want to edit in the formula
bar.
3 Make any changes that you want.
4 Press Enter.
2
1
TRY ThIS Click the Excel Help button. Then, in the Excel Help
dialog box, type common formulas in the Search box, press
Enter, and click Examples Of Commonly Used Formulas in the list of
available topics. The Help file that appears has quite a few examples of
formulas that you might want to create.
CAUTIoN Be sure that there’s no space before the equal sign
in your formula. If there is, Excel interprets the cell’s contents as
text, not as a formula.
Search JabSto ::




Custom Search