O'Reilly logo

Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours by Trudi Reisner

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

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

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