Chapter 12. Building Formulas

Formulas are the heart and soul of a spreadsheet, and Microsoft Excel offers a rich environment in which to build complex formulas. Armed with a few mathematical operators and rules for cell entry, you can turn a worksheet into a powerful calculator.

Formula Fundamentals

All formulas in Excel begin with an equal sign. The equal sign tells Excel that the succeeding characters constitute a formula. If you omit the equal sign, Excel might interpret the entry as text.

To see how formulas work, we'll walk through some rudimentary ones. Begin by selecting ...

Get Microsoft® Office Excel 2003 Inside Out now with the O’Reilly learning platform.

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