Excel Workbook For Dummies, 2nd Edition

Chapter 6

Building Formulas

IN THIS CHAPTER

Constructing simple arithmetic and comparative formulas by hand

Creating formulas that use Excel’s built-in functions

Editing formulas

Altering the order in which a formula’s operands are calculated

Creating external reference link formulas

Controlling formula recalculation

No one disputes that formulas are the center of almost every worksheet you create. Building formulas — both those that perform simple arithmetic calculations as well as those that perform more sophisticated computations using Excel’s built-in functions — is a critical Excel skill. The exercises in this chapter give you a chance to practice building both types of formulas as well as modifying how and when the formulas in the worksheet are recalculated.

Building Formulas

All the formulas you build in an Excel worksheet, regardless of their function and degree of complexity, ...