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

Using Cell References

Cell references are cell addresses, such as A1, B4, and C5, entered into formulas. Cell references are what make spreadsheets so flexible, because as the values within cells change, the cell references stay the same: cell B4 is cell B4, whether the value inside it is 2 or (5*(4^3))/7. When you build formulas with cell references, the formulas not only stay smaller and more manageable, but they also stay the same even when the contents of cells change. Following are tips for using cell references.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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