• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Entering Formulas

As you learned in Chapter 1, “Understanding Excel Worksheets (Spreadsheets),” every formula begins with an equal sign (=) and can include cell references, mathematical symbols (such as + and –), and actual numbers. You enter a formula in the cells in which you want the formula’s results displayed. Excel gives you two options for entering formulas: You can use the point-and-click technique or type formulas. These techniques are described in the following sections.

Using Point-and-Click Entry

The easiest and most foolproof way to enter a formula is to use the point-and-click approach. You simply start your formula with an equal sign, click cells to add their addresses to the equation, and type the required mathematical symbols. The following instructions lead you step-by-step through the process:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint