O'Reilly logo

Microsoft Excel X for Mac OS X: Visual QuickStart Guide by Maria Langer

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

Formula Basics

Excel makes calculations based on formulas you enter into cells. When you complete the entry of a formula, Excel displays the results of the formula rather than the formula you entered.

Here are some important things to keep in mind when writing formulas:

  • If a formula uses cell references to refer to other cells and the contents of one or more of those cells changes, the result of the formula changes, too.

  • All formulas begin with an equal (=) sign. This is how Excel knows that a cell entry is a formula and not a value.

  • Formulas can contain any combination of values, references, operators (Table 2), and functions. I tell you about using operators in formulas in this chapter and about using functions in Chapter 5.

  • Formulas are not case ...

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