718
Chapter 26 Using Formulas and Functions
Entering and Editing Formulas
Formulas add intelligence to a workbook. Using formulas, you can manipulate values (text,
numbers, or dates), perform simple or complex calculations, and display alternative results
based on logical tests. A formula can be as simple as a reference to another cell, or it can go
on for hundreds of characters, with as many as seven functions nested within other func-
tions; regardless of its complexity, however, a formula must begin with an equal sign (=). If
you start a formula with a plus sign (+) or minus sign (–), Excel adds an equal sign to the
beginning of the formula.
Formulas ...