References in Formulas

As mentioned at the beginning of this chapter, the use of constants in formulas defeats the purpose of a spreadsheet. When you use constants, you have to change the formula each time a value changes.

The content of a cell is handled through a cell reference. A reference tells Excel which cell contains the values used in a formula (see Figure 3-5).

Using cell references to multiply the day rate by days.

Figure 3-5. Using cell references to multiply the day rate by days.

When you enter references, make sure that the formula doesn’t contain spaces.


Formulas are not case sensitive. Excel converts all references from lowercase to uppercase if the syntax of the formula is correct. If ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.