Chapter 3. From Numbers to Formulas

Calculations in Microsoft Excel are achieved through formulas. Formulas are entered differently than other data, although you probably won’t notice the difference.

The procedure for working with Excel worksheets and working on paper is basically the same, except that when you work on paper you have to write down the initial values and then manually work through each step of the calculation. In Excel, the initial values are called input values, and you specify the algorithms in a formula to produce a result based on the input values.

A spreadsheet has the advantage of letting you use the calculation scheme you have created over and over ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out 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.