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

Chapter 21. Using Formulas and Functions > Using Range Names and Labels in Form...

Using Range Names and Labels in Formulas

Understanding the logic of a complex formula can be a challenge, even when you entered the formula yourself. To make formulas easier to understand, you can enter cell references by using named ranges. This technique is especially useful with cells that contain constant values such as interest rates, loan amounts, sales tax rates, and discount formulas, because you can define a handful of input cells and then plug the contents of those cells into formulas on any worksheet within the workbook.

You can define range names explicitly, or you can enter cell references that are defined by the labels on rows and columns.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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