O'Reilly logo

Picture Yourself Learning Microsoft® Excel® 2010 by Laurie Ulrich Fuller, Deidre Hayes, Jeffery A. Riley

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating Formulas

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required