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

Chapter 2. Using Range Names > Naming Constants

Naming Constants

One of the best ways to make your worksheets comprehensible is to define names for every constant value. For example, if your worksheet uses an interest rate variable in several formulas, you can define a constant named Rate and use the name in your formulas to make them more readable. You can do this in two ways:

  • Set aside an area of your worksheet for constants, and name the individual cells. For example, Figure 2.8 shows a worksheet with three named constants: Rate (cell B5), Term (Cell B6), and Amount (cell B7). Notice how the formula in cell E5 refers to each constant by name.

    Figure 2.8. Grouping formula constants and naming them makes worksheets easy to read.

  • If you don't want to clutter a worksheet, you can name constants without entering them in the worksheet. Choose Insert, Name, Define to display the Define Name dialog box. Enter a name for the constant in the Names in Workbook text box, and enter an equals sign (=) and the constant's value in the Refers To text box. Figure 2.9 shows an example.

    Figure 2.9. You can create and name constants in the Define Name dialog box.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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