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

Chapter 44. Letting Excel Do the Math > Using Range Names in Formulas

Using Range Names in Formulas

Using range names can sometimes help you create and troubleshoot formulas. The use of range names is especially important if more than one person is going to be working on the file because names are easier to understand than cell references. For example, a cell named SALES_TAX would make a sales tax calculation easy to understand and locate.

You must name a range before you can use it in a formula. If you remember the range name, you can type it into the formula in place of a cell reference. Remember, though, that you must type the range name perfectly, or Excel won't accept it. If you don't remember the exact name of a range, let Excel provide the name for you.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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