TO CREATE A FORMULA, you type it into a cell. After you press Enter, the result of the calculation is displayed (rather than the formula itself). If you click the cell, the formula you typed appears in the Formula bar (see Figure 2-2). All formulas begin with an equals (=) sign, and typically include a reference to one or more cells. The values in the referenced cells are used when calculating the formula result. These cell values can be static (meaning they don’t change) or the result of another formula. For example, in cell E12, you might enter a formula that adds monthly sales for the Northwest Region to calculate the Second Quarter sales total. In cell E16, you might enter a different formula that references the value in ...

Start Free Trial

No credit card required