O'Reilly logo

Special Edition Using Microsoft® Office Excel® 2007 by Bill MrExcel Jelen

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

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

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