• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 12. Working with Named Ranges > Using Range Names in Formulas

Using Range Names in Formulas

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:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint