Table of Contents### Using Range Names in Formulas

Entire Site

The benefits of naming ranges have been extolled throughout this chapter and in Chapter 3—navigation, editing, and explaining a worksheet's content is made easier through the use of named ranges. Probably the most significant benefit, however, is the use of named ranges in formulas. Rather than selecting a cell or range of cells (or typing their cell addresses) for use in a formula, you can select the named range from a list. This eliminates the margin for error (unless you named the range incorrectly) and makes it easier to edit a formula. The formula `=(Sales_Total*Proj_Increase)*.85` can be easier to build than `=(C8*M25)*.85` because you don't think of your numbers as C8 and M25—you think of them as what they are: your sales total and projected increase.

If you effectively name all the cells or ranges that you'll need to use in formulas, creating a formula can be as simple as shown in the following steps: