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

Naming Ranges

Up to this point, when you have created formulas or functions or formatted cells in a worksheet, you have specified cells and cell ranges using the cell addresses. You also can name a cell or range of cells. For example, you could select a range of values and assign that range a name. You also could select a range of cells that includes your expenses and name that range EXPENSES. You then can name a range of cells that includes your income and name that range

INCOME. It would be very simple to then create a formula that subtracts your expenses from your income using the range names that you created. The formulas would be written as follows:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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