Referencing Cells

In addition to typing values into your worksheets, you can enter references to cells. Using cell references is often more effective than typing actual values when you want to build formulas. If a value in a referenced cell changes, the formula that points to the reference is updated automatically. Best of all, one cell can be referenced in an unlimited number of formulas. A cell reference does not need to contain an operator unless you want to use it to perform a calculation.

For example, if you're calculating the amount of sales tax due on a car purchase, you can reference the cell that contains the current sales tax percentage in each formula. If the sales tax percentage changes or you enter it incorrectly, updating the percentage ...

Get Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.