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