• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part I: Everyday Worksheet Tasks > Working with Formulas

Chapter 6. Working with Formulas

  • Understanding formulas

    Before you begin writing formulas, you need to understand some basic principles about how formulas work in Excel.

  • Enter formulas

    Construct formulas to carry out calculations using values, cell ref-erences, operators, functions, and range names.

  • Edit formulas

    You can go back to any formula and edit it, either in the formula bar or in the cell.

  • Arrays

    Use array formulas to treat ranges of values and formulas as a single group, replacing repetitive formulas and saving memory.

  • Naming cells

    Naming cells can make it much easier to write and interpret formulas and to select cells or cell ranges.

Formulas are the core of an Excel worksheet. Formulas do the work—that is, the calculations—that we used to do by hand or with a calculator. Without formulas, there would be no point to using an electronic work-sheet such as Excel.

You can use formulas to do simple calculations involving addition, subtraction, multiplication, and division, as well as to carry out very complex financial, statistical, or scientific calculations. You also can use formulas to make comparisons and to manipulate text. When you need to carry out any calculation whose result you want to appear in a worksheet, use a formula.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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