## Chapter 21. Controlling Formulas

In this chapter

Formula Operators 410

Understanding Error Messages in Formulas 414

Using Formulas to Join Text 415

Copying Versus Cutting a Formula 418

Automatically Formatting Formula Cells 419

Using Date Math 421

Troubleshooting Formulas 423

While you can go a long way with simple formulas, it is also possible to build extremely powerful formulas. The topics in this chapter will explain the finer points of formula operators, date math, and how Excel distinguishes between cutting and copying cells referenced in formulas.

### Formula Operators

Excel offers the mathematical operators shown in Table 21.1.

##### Table 21.1. Mathematical Operators

#### The Order of Operations

When a formula contains many calculations, Excel will ...